Running & Setting Up Queries - Page 159

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Summary break down and grand total by Billiam I have Instructors in 8 regions. Each Instructor can posses up to three qualifications (called H, R, and W). I have a report by region showing: How many...	September 11th, 2009 07:10 PM by Billiam	6	129
User Prompt for Month to find Date Range by sonofroy I have a query that prompts users to input and . I have realized that the dates that will be put in are always the beginning date and the ending date of each...	September 11th, 2009 06:39 PM by John Spencer	3	115
Append current object to a new table by Amelia I am not real familiar with append queries. I have one set up, but I would like it to be a little more end user friendly. I am using Access 2007, I have an...	September 11th, 2009 06:36 PM by Amelia	1	118
Help!! Extracting data from a single field by Duyen I have one field that contains City and State; but I really want two fields (one for City and one for State) For Example: filed 1 Kansas City MO Kansas...	September 11th, 2009 06:32 PM by Duyen	2	122
Multiple users opening queries on shared network by bcaron I have a database saved on a network. When I open a query, I get the correct results. When another user on the network opens the same query, this user gets...	September 11th, 2009 06:03 PM by Sylvain Lafontaine[_2_]	1	103
Query to filter next to last oper by Cam Hello, I am trying to create a query to pull the next to last operation for all the part# but not sure how to achieve this. There are part# with several...	September 11th, 2009 05:08 PM by Cam	4	118
Join issue Access by AdamPoz Hi, I have an issue with a join query. I have 2 tables 1 containing information on monitors the 2nd table contains information about computers. They can...	September 11th, 2009 12:12 PM by AdamPoz via AccessMonster.com	4	185
Too many rows output by query by Len B[_2_] I have two Tables called 'Equipment' and 'Movements' Joined on the primary key of Equipment. There are many movements per item of Equip. Here is the...	September 11th, 2009 08:06 AM by Len B[_2_]	5	117
Query gives me a warning when I ru it... by Phil Smith This query runs OK, but I get a warning.: The specified field '. could refer to more than one table listed in the FROM caluse of your SQL statement. Any...	September 11th, 2009 02:01 AM by Allen Browne	1	131
to display specific group by result in Crosstab query by hoachen I am wondering, is there a way to display the result specifically on the Pub? .. For example, i group all the same name catagory and then only those i want... ( 1 2 3)	September 11th, 2009 01:16 AM by hoachen	21	374
Passthrough queries and "Select Data Source" dialogue box by jmillerWV Hello again all, Have a SQL backend, and an Access2003 front end. When I run a passthrough query I get the "Select Data Source" dialogue box. Is there a way...	September 11th, 2009 01:11 AM by MGFoster	1	145
replace in a query by LG I have a field with the following message: Must be submitted prior to March 31 of the calendar year following the year in which the service or supplies were...	September 10th, 2009 10:06 PM by Clifford Bass[_2_]	6	104
need help making a query (crosstab instead of Pivot tables?) by webicky I'm trying to make a query that will imitate a 2-layer pivot table (as a- the pivot table takes a while to load up and b- i'd rather have the data in a query...	September 10th, 2009 09:43 PM by webicky	3	133
simple OR sql will not work as examples show by Rocky I'm trying to simply display all records with the EndMinute field value of 0 or 15 or30 or 45 When I use the following code... SELECT Cust., Cust.Client,...	September 10th, 2009 09:01 PM by Rocky	3	303
Query pulling dates from one month prior to requested month by Thorson A while back I changed my code to pull in all records from the date on a form up until the 5th of the next month. However if the entry date of the record...	September 10th, 2009 08:54 PM by Thorson	0	148
Table drop-down values disappear in query by Access Non-Pro[_2_] A field created in a table using the Lookup Wizard displays the proper drop-down values when viewed in the table. However, when that field is added to a...	September 10th, 2009 08:44 PM by Duane Hookom	7	176
query for missing value by Bryce hi, i am using access 2003 and have a .csv that i imported into a table. i need to extract a list of computer names that do NOT have our custom service...	September 10th, 2009 08:08 PM by KARL DEWEY	5	128
Update query should not fire if prompt is null by Randy[_15_] MS Access 2000. I have an update query that has a prompt for a date. User is supposed to enter a date, then it is updated to the table. But if the user...	September 10th, 2009 07:24 PM by John Spencer	1	115
Creating a field based on another column using Switch or IIF? by lsetla1 I tried the following: Expr1: Switch(='Davis High School' Or ='West Valley High School',â€˜Yakimaâ€™,='Tonasket High School',â€™Tonasketâ€™,True, ) ....but...	September 10th, 2009 07:05 PM by MGFoster	7	208
Question using Min or First for a date field by Sean In my query I am asking it to pick the min or first date associated with an Sales Doc # and a material. There is also a field called LDB. On the line with...	September 10th, 2009 06:55 PM by MGFoster	1	121

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed