I have a query that I would like to return all items that are overdue (ie the
due date is less that today
I have tried the following
<Date()

In an update query, can I somehow do the following:
If Condition 1 is met  update a field in a table from null to "-1"
If Condition 2 is met update the field to  "-0.5"
If Condition 3 is met update the field to " 0"

I need the results of a query in several other queries.  The problem is
that the first query cannot be constructed using SQL, but can be in
VBA.  How can I refenence the VBA query results in other queries?
The problem all steams from not being able to use another query or

I have a field called WeeklyRevenue and another called WeeklyTarget.  I have
a calculated field in a report called PercToTarget which is WeeklyRevenue
divided by WeeklyTarget.  There are some records that have no Weekly Target
and a zero is in the field for these records.  ...

Seems simple, but can't get it to work.
Two tables with a 1 to many relationship.
tbl_Projects (the one)
tbl_Activity_Log (the many)

My database collects a lot of Yes/No questions.  The query is date specific,
and it asks to find how many ESA tune-up were performed and of those a yes/no
field asks if the customer invested in an ESA renewal.  The query shows this
with no problem.  The problem I have is how can ...

I have a calculated field using a nested IIf that basically creates either
the word "cataract" or an empty cell. It works fine but I want to add a
Criteria that returns ONLY the rows with Cataract. When I enetre the word
"Cataract" or Like "Cataract" it runs like a parameter ...

Ok, I can do the following
SELECT COUNT(cq.qid)
FROM completed_questions cq
UNION

When I display a table, the records are in the right order, but when I
export the table as a fixed length text file.   The records in text file are
out of order.     Why it is doing that and how I can fix it?  I use Access
2000 and Windows 2000.  

I'm hoping to create a pass through query to retrieve records from a large
(6.4 million record) Oracle database.  I want to limit the records chosen
using a local access table.  I've written the SQL, but so far no luck.  
Either my SQL is wrong, or it isn't possible to join a ...

I have query that pulls a parameter from a list box on a form.  The
query refrences the list box like such:
Where (Take_Offs_tbl.House_Code)=[forms]![frmschedulea]![listbox8]
My question is this.

I have a form that is supposed to do calculations based on an already
calculated field and a manual entry but when I set my control source to the
already calculated field in my data base I get #NAME?? showing in the
textbox.  What is causing me this problem

Help please needed for the above.
I have a query (call it A) with Parameters defined in it( call them
ParmNameA1 and ParmNameA2), that uses two sub-queries (say B and C) each with
parameters as well.

I've been struggling with a query in Access 97 and wonder if someone can
point me in the right direction.
I have a customers table and the fields I need in the query results are
customer name, postal address & email address.  There are a number of records

Im looking to see if its possible to create a drop down menu in a query. I
already have it so it asks the user a question. I actually have 2 problems. I
am searching according to 3 criteria right now. The present year (needed
because it calculates a value), the company (which i ...