Is there a way to search all the queries in an Access database to see if they
use a particular field in a table?
I would appreciate any help or pointers.
Thank you,

I need to select data between two time periods by month.  How would I write
this code and where would I put it in my query?
Thanks

I have a query that collects the information from a database for the item
sales for a customer during a particular period.
i would like the query to add the item prices and give me a total for each
invoice.

I have 2 sql
The First
SELECT G05_LacGastIngr.CodProd, G05_LacGastIngr.CodPer,
G05_LacGastIngr.CodLac, Sum(G05_LacGastIngr.Cantidad) AS Cantidad

I have 4 different queries with the same 3 fields which I need to combine but
for some reason I can not get this very simple UNION query to work and I can
not figure out why. It's telling me that there is an expected SQL statement
missing

Hi. I have a query that joins two other queries. I want to create a report
using the final query. Query 1 lists sales orders. Query 2 lists production
schedules. When I join the two queries (query 3) by item and warehouse, I get
duplicate records for both sales orders and ...

I am trying to identify whenever x (in this case 5) sequential values in a
field occur in a table and write these values to another table in the same
database.  Can this be done in a query or is vba coding required?  Any help
would be appreciated...

I am still a novice with SQL and am trying to figure out how I can combine
the following 2 queries into 1 using a subquery.  As you can see, 'qry_New
Client Appt Info' is built upon 'qry_Num of Appt by Client'.
qry_Num of Appt by Client

I have an update query that is not giving results as I would want.
Two tables:
tPriceList
   PartID

Thanks to all of you I was able to add the below expression to my query to
give me the date of the Friday of the week represented by the value in my
date field.  
However, I would like to understand what's happening as opposed to just

Can someone please correct my running sum?
I have a query1 with the following fields: Item, Description, FQty
When  I run query2
SELECT Query1.Item, Query1.Description, Query1.FQty, DSum("FQty","Query1",

I have some raw Excel data in the format:
2170696969
2021965
2023241

I can't get an INSERT statement to accept a UNION.  Is this a fact or am I
really missing something here?  Here is an air-example.  
Should something like this work?
insert into mytable (myfield) select field1 from table1 union select field2

OK this is what I need:
Need a query to select top 5 from a list and to sum every other result as
"Others", basicaly I need the query to return SIX results.
Table "Scores":

I am trying to build a table from data stored in our SQL server, my problem
is I want all accounts specified in the query to be listed regardless if they
purchased a particular item or not. If they didn't then I want a zero for
that record however I am having trouble ...