Hi,
I want to calculate (date) difference of column B based on grouping in
column A. Problem is similar to one of the threads on the discussion board
except  the fact that for a value in colum A  there can be same value in

My question is can wildcards be used in the parameter of a query.  I have
tried using wildcards but have had no luck.
I have a form which uses queries to populate three controls, cboState,
cboCounty, and cboJurisdiction.  These controls must be filled out in the

Can I add a calculated field to an adp query which will automatically provide
an incrementing value for each row (starting at 1) ?

Database background:
I have a reconciliation database that essentially loads 2 stock files and
checks that the two reflect equal holdings.
The files are linked through a matching table that matches the stock codes

I am having trouble with a query/macro that has stopped working.  I have 618
records in the table, and it won't pick up any data after about the 615th
entry.  The table is allowing more information to be put into it, but when
you run the macro/query combination to pull the ...

I have two tables that are the same, no validation rules all field names are
equal.  Now when I go to append them I get a type conversion failure, key
violations, lock violations, and validation rule violations?????  Why is this
happening?  And, if I ignore it only appends 50,313 ...

I might be running in to a larger update query statement.
Has anyone else dealt with this?  If you have do you recall how you worked
around it?
Thanks,

Good evening all,
I need to reference a column from a query in another column and I don't know
how, or even if it is possible.
Basically, say a field in the query from the table is birth date, I create

I am having trouble with the following SQL statement due to the quotation
marks involved. I seem to have a mental block when it comes to quotation
marks.  Can somebody give me a hand here.  Any help would be appreciated.
SQLStatement:="SELECT tbl_expirations.Expiration_Date, ...

I've created two tables; Company Info and Editorial Coverage.
I'm trying to link the Company name, address, city, state, and zip from my
first table (Company Info) to my second table (Editorial coverage). I've
created a combo box that pulls the value from one field in my Company ...

Hi , can you help me to make a query that shows only the date of a stock(Date
of Last Stock Check)
that been from 40 to 59 days
I really apreciate your help

i need a query that will return the date (in my case the date of a sample)
closest to date X.
these are my fields: ingAutoNumber, strSerum#, dtmDate (this is the date i
need it to return closest to date X)

Table data: you can see that there are differences after the data is broken
down
Scan steel receiving                     Date                     Kanban card
P063141049 682875 4480    11/28/2006    063141049 101

Using this code:
SELECT qry_CarrierSummary.Carrier, qry_CarrierSummary.[Sub Pay],
qry_CarrierSummary.[Pay for homes], Format(CInt([Sub Pay])+CInt([Pay
for homes]),"Currency") AS [Carrier Pay]

can you lock records in a query or do I have to create a form to keep the
users from modifiying some records.