Can someone look at this and tell me what I should do to make my query
updateable.  Thank you!
SELECT [Quality Alert Table].Mld, [Quality Alert Table].Coat, [Quality Alert
Table].Assy, [Quality Alert Table].Service, [Quality Alert Table].[Quality

I would like to make a query based on a selecion (more than one
selection) in a subform in datasheet view.
the point is to be able to use this query as a base for sending email
to the selected posts, delete the selected posts or perfor other

How do I subtract the current date from a date in a table field?
I have dates in a field, e.g. 7/15/1980, and in my query, I have the current
date, Date(). I am trying to subtract the two and get the age in years. My
function works, but I am getting a message box, stating that I ...

I want to make a query but I am unsure how to go about it. Here is what I
have:
Jobs({pk}jobID, drawingID)
Sample Data:

It'd be appreciate if the "QUERY" can do instead of inputing values by the
"FORM".  The table is lack of the values, so I would like to place them,
whether it could be done by the "QUERY". The values is as the same as the
first beforehand records such as: 33, 0 ,0 ,0 34 ,0 ,0 , ...

I would like to create a query whcih dies the following but not sure how to
as cross tab query doesn't allow multiple data.
I would like to have an end result as follows
1st column has all the store details

I have a table has the following layout and about total of 3600
records:
ID#    group      dwgs                 spec
1       Arc           A-A-0001         01400

I'm using Access 2003.  I have a table with a field named DeletionDate.
Majority of all the records are blank except for a couple that have dates in
them.  I'm using the DeletionDate in a formula in Crystal Reports XI.  I
think the formula in crystal may not be working right because ...

I posted earlier and fear I may have worded things wrong.
I also tested each individual query to ensure that it was down to these two.
I have a strong feeling that the problem is in the second query I had posted:
Update

I'm trying to count how many time
each user have been logged in to my website
and then sort them desc. But I keep getting
an error.

I have a table [x confirmed] with the following fields
'name' (yes I know - bad idea - but it works OK so far and I'm stuck with it
for now!)
'practice'

I know I'm missing something terribly obvious here, but I just can't put my
finger on it.
I have a table, with many linked tables, and I want to get data from that
table and its linked tables, but only for one record in the "main"  table.

I have a date/time field where a date look
like this 31-12-2006 24:00:00
Now I want to get all the records with august month.
I have tryed to use this SQL -

I am trying to build a parameter query for which I would enter two values and have all the values in between returned. For example, a list of numbers from 1 to 200.
On the query I have the following on the Criteria:
Between [Enter Product min number] And [Enter product max number] ...

I have a parameter query that prompts user for date. I'm not sure how to
explain this, but I've created a field in the query that pulls only the date
information from the date/time field in the table and not the time. I did
this by using DateValue([Call_Date]).