I have been trying to write a query to count the number of start
dates for projects that have not started yet.

I have 6 text fields labled Eqp1, Eqp 2,...etc.  I want to combine the data
in the fields starting with Eqp6 and working backwards.  All of the fields do
not contain data.  The end result should look like:
Field 6 text * Field 5 text * Field 4 text* etc.....

I’m building a query that I would like to sum quantities of a part number
used on multiple Purchase Orders
Example
PO    Item #         qty    sum

Hello, is there a way to convert the AS400 date 1071101 where 107 = 2007, 11
is month, 01 is the day?  I'm attempting to use the Format function TDate:
Format([AS400DATE],"??????????")  TIA!!!

a)I have data in an access database which was imported  but the some of the
times are stored as 1/1/1900 10:35:00 instead of just 10:35, this wreaks
havoc when i try to sort them, I did see a CDec() function in access help,
but is not available?  I did try a CDbl() just to see ...

I'm having a brain blip - in a query I would like to test if the value from
one field (example:  Field 1: "ANN" Field 2: "ANN SMITH") is contained in
another field of the same table.  If it weren't a field I would use LIKE.
Thanks in advance.

I use the following query to provide selected input into another query and it
works fine as long as I hardcode the 9919 and 'SS ID 13'.  there are other
column headings such as 'SS ID 14', 'SS ID 5' and so forht that I need to use
in the query depending on which event a ...

I have a query that  (see SQL view below) where I need to return the column
heading ( or related date for that column heading) for the first field in a
list of 15 fields, that is below 1.  I wrote a bunch of nested IIF
statements, but there are one too many columns and I'm ...

I have read all of the posts on this forum about Pass Through queries and I
just do not get it.  Does anyone have any sample code of how they used data
on a form as criteria in a Pass Through query.  Particularly for date ranges.
I have a Pass Through query that looks like this.

Can anyone tell me if either of the following can be done, and if so, how?
1.  Can you put comments in a query?
2.  Can you embed an informative prompt to the user in a query?
I have an Insert query (rarely executed) and I would like it to give an

I have not worked with MS Access in a while (5 yrs) and need help to filter
150,000 data points.  I am trying to determine unique entries base on several
key criterias.  I did import the data from our database with ease.  Any help
would be great.

How / can I use a paramater query with a crosstab query in access 2003.

I have a 3 tables,
table 1             table 2            table 3        
ID                    ID                   J_ID            
Part Number     Part Number    NHA_ID      

I have a union query as follows:
(select * from qrysumofstdhrs) union (select * from qrysumofothrs) UNION
(select * from qrysumofdthrs)
ORDER BY vendorid, workername, workdate;

How do I display all properties with a price between £75000 and £95000