I have a small database which keeps track of downtimes for our manufacturing
machines.  The user will enter a date and time when the machine went down,
and when the machine is back up the user will enter this data as well.
I am now working on different ways to look at the data and ...

I want my query to sorth through dates. I want it to only pick-up items that
are later than the current date. Does anyone know how i can do this ( does
anyone knoe the equation)?
Thanks

I have a select query that has begun to malfunction. Its purpose is to
identify those records who have expiration dates three months from the
current system month, i.e. today we would see those which will expire
in March 2006. The expiration date is calculated in the query from the

Hi  I have a table the records of which have two addresses, work and home.
We also have a preferred address field.  I need to do mailings to the whole
database using their preferred address.
Is there a way that I can create a query to select the records into a single

I need help creating a criteria that finds data for the previous week. Our
week starts on Mondays and ends Sundays. So if I ran it today (Wen dec 7) it
would find data from Mon Nov 28 through Sun Dec 4th.
Thanks,

I am getting an error message when trying to create a SQL pass-through query
and a value has a " ' " in it.  For example:
Select * from Northwind where Company="John's Tire Shop".  I get an error
message of SQL thinking the "John's Tire Shop" is a column.  I know that in

Is there a way to put a query, either in SQL or some other format, into
a vba event so that I can add some "if...then" statements?
If so, what sort of syntax do I need to surround it with?

I need help I am trying to do a query for evaluations. I need to be able to
count how many times a number is appears. This is the SQL that I have
SELECT IIf(Course.Q1=0,"0",
IIf(Course.Q1=1,"1",

how can I  point queries to a field on a form?

I have a table with 1 row (Fees) and 3 columns: Fee, Next_Fee_Date, and
Freq.  I want to write a query that goes like this:
If Fees.Next_Fee_Date < now() then
 1) Insert Fee into another table with todays date

Kind of hard to put in a subject header for this.
Basically, I want to run a query so that it picks up which records have
today's date in a specified field.  But when the query is run again, it
will not pick up that record again.

In my C# application all queries runs well both with MS Access and SQL Server
databses. But only the following query runs well on SLQ Server2000 but with
MS Access gives error
=> "IErrorInfo.GetDescription failed with E_FAIL(0x80004005)."

I've got quite a dilemma on my hands.  We use a staff database to monitor
all staff issues.  When it was designed it included a section on Sickness
monitoring.  However this section is based on:
Absence Number (Primary)

I have added 2 new Functions as Modules, one works fine but the other gives
the following error when called "Undefined Function xyv in Expression"
Any ideas?

[code]
On Error GoTo Err_ErrHandler
   Dim strCartName As String
   Dim updateQry As String