I am trying to develop a query that will have 3 left joins...of course I get the ambiguous error message, so I created it using all inner joins. Hoping I can...

I'm trying to format a query to determine if the hire date of an employee is within 3 months before January of the current year. Here is what I have so far...

Could someone assist with the following query? In short, I want to see the count of updates per day, and a total, from 3 different tables. The query runs OK,...

Hello, I am going to try this again starting fresh from my other posts. I am trying to develop an all inclusive query on our inventory. Each fical term we...

Is there a way to combine the results of three queries into one.

How would I combine 3 seprate queries into one one query? All 3 queries have similar tables in each. Do I do make table, append or? What is the best way to...

I currently have a 3 table query and need to edit within it. The only editing i need to do is to assign a field using a drop down list box. I have joins...

I currently have a query that runs matching data from one table to either one table or the other i.e. Serial ID matches that in Table 2 or Table 3. I need to...

I want the query to return 1 row for each ORDER- which is unique for each clientid and ticket#(combined). The order can be based off of a quote (from quote...

this is probably obvious but i cant see the wood for the trees. anyway, i have a query with three tables. table1 has unqiue primary key (id) that is joined to...

hello all, I tried in all possible ways, but I can't find a solution... I've got 1 table with 2 fields only : Invoice number, Invoice Date. I wish to retrieve...

I need to create a query which when completed will popluate a report that has a 3-tiered column layout. I have multiple Stations (numbered text field like:...

I need to create a query which when completed will popluate a report that has a 3-tiered column layout. I have multiple Stations (numbered text field like:...

I have 4 class categories (A,B,C,D) with 10 class A1,A2,A3,A4 ...etc) in each category. There will be 1 checkbox selected from each category A,B,C or D. I...

Hi, I'm trying to choose the first 30 days when a new entry comes into the table by using this formula: =+30 and with in the same query, i want to choose...

I have a table that has 3 date fields that are tied to a pkg no. . Each day the packages move thru the completion process the next date field would be...

I have 30 different tables and i need to pull the date, time,ID, plus a couple other columns from each. Can i do it in one step?? So i want to tell the query...

Im know access fairly well, and I am creating a database that will keep up with contracts for customers. I need to develop a report that will allow me to see...

Help! I can not solve this. Must be SQL, as I connect through Jet. Pmts not fully Applied (such as clients who prepay), must be accounted for. Database...

This query works: INSERT INTO ( Company, Address, City, State, , Phone, , , ) SELECT Customers.CompanyName, Addresses.Address, Addresses.City,...