I have a query with multiple criterias in one or more fields.  I have updated
this query to include yet another criteria in a different field and for some
wierd reason, it is not returning the value of my selected criteria.  So
instead of returning back certain records, it gives ...

I am trying to write a select query to return records within 10 days of being
due.  For example, my field name is SA_To_Be_Mailed_Date.   I would like to
have a query that lists the records that have this date within 10 days of the
current date.  I'm not sure how to write the ...

What about a query that only displays the last three entries by date.
So instead of
Unit     Value        Date
a          10            09/18/2005

This is driving me nuts!
I have text field [APPT_DT_TM)which actually contains a concatenated date &
time value e.g
200605021541

I am doing an update query with the following expression in my Update to
field. It worked fine yesterday now I am getting the datatype mismatch error.
Can someone look at this and tell me if it is ok or? Thank you
Field: Countersignatures

I currently have 2 queries that produce the following recordsets:
Query1
============================
Name         Date              AmountSpent

Help me write this for MS access, I'm used to Oracle, and I'm really
bad at coding SQL! -
SELECT Users.*, group_1, group_2, group_3
from

I received this response from Mr. Walsh and it almost answers my question but
is not 100% complete. I need to take my expression (see below) and update it
to another table and field that is a text field and is already a Y or N. I
have the expression and it is correct. But I need ...

I'm trying to take information from a table that has defect information for
for each part produced and the date reported.  I want to take this data and
summarize by month the number of defects per month.  The difficulty I'm
finding is that if I group by the date in a query it ...

I have some data that is in Number, Long Integer format.  The data represents
seconds.  I would like to convert to hh:mm:ss.  Any suggestions?

I have a button on a form that has a macro attached to its ON CLICK property.
The macro opens/runs a query to delete an employee the user indicates.  The
user is prompted to enter the employee’s last name, first name
(concatentated).  Then takes the user to the first record.  ...

I have two reports that I want to run based on a selection the user makes in
a combo box.  I have two buttons on my form as well.  The first button runs a
basic query that uses the combo box selection as the parameter for my query.
The second button runs a union query, which works ...

I have an update query but the error message keeps staing I have a Parameter
value error.
states: dbo_tblproduct.AvailableOnline then has a box for a parameter. IT IS
NOT SET UP FOR A PARAMETER! Any ideas on this one?

Ok, first things first, thanks for your help whoever you are, I have looked
thru this board enough to know that the help given here is first class and
very professional.
That said. I am trying to generate a report that displays a volume and a

I have a database that have a control called case.  Each case have multiple
events.  These events have date stamp on them.
What I am trying to find out is how can I show only the most recent event on
each case?