I have a report based on a query.  In the report I'm trying to create a text
box that will count the number of records in the query, however the =Count(*)
expression, when used in the report, results in an error.  Any help?
Also, in the same report I'd like to be able to create ...

Can someone help me?
I have a table that I am trying to run a query off of.  The table has
field that is in Date/Time format and the date is shown as "99/99/00
format or "10/24/06".

I have a created a combo box with 4 different fields.  I want to now create a
query that will total the number of selections that were made for each field.
When I use the sum query, I get one total.  How do I get the total or count
each field seperately in the combo box.

I have query criteria as follows
WHERE [Order Date] <= Date()-21 AND [Issue Date] Between Date()-3 and Date()
AND [Refills]<>0
I need to query all prescriptions with Order Dates over 20 days old with

I have a database with links to our accounting system (written in Visual
FoxPro). We are getting ready to do a lot of key changes to customer
numbers in the accounting, which means we have to make the same changes
in the Access database to keep consistency with the data. Is there ...

I have a table that in Field 1 has A, B, and C data.  There are numerous
records (rows) with either A, B, or C in this field.  For each occurrence of
A, B, or C there is Field 2 that has the value C, D, E, or F.   I want a
query that can look at each occurrence of data A, and if ...

i am using Access 2002.  I want a field in a query to give me a number with
no decimals.  Currently I get 2 decimal responses.  How do I do that?
Thanks in advance! Paul

I have two tables.  Some items in the tables match and I want a query that
pulls the items in the larger table that are not in the smaller table.  

I am trying to obtain the top AND bottom 25 values in the same query for a
report.
The only difference is the sort order on the pertinent field but I get an
error telling me I have different fields.

In MS Access, I created a query to link between two primary key field in
order to show those that have the same number, and then I wanted to use that
query as filter in order to filter in each table to come out with those that
don't show in BOTH table,  however MS Access didn't ...

Am using access 2000.
I need to work out the number of days i have a document before passing it
on.  The received date is on 1 record and the date sent is on another.  Is
there an easier way of working out the days without having to add another

I have the following code and get an error message at the docmd.runsql line.
What is wrong with my syntax?
Private Sub Form_Close()
Dim datCurrDate As Date, datNewDate As Date

    I am trying to come up with a piece of SQL code that will select
data from multiple tables.
    The table names are [General Drawings] [Fabrication Drawings]
[Sketches].

Good afternoon,
I have a query that returns multiple results i.e. question 1 and a score of 1
question 1 and a score of 1
question 1 and a score of 1

Next MakeFrom: DLookUp("[MakeFrom]","2","[FramePartID.] = " & [FramePartID]+1)
the table is "frame make from" with a field "makeFrom"
the alias on the second is "2"
FramePartID can refer to both tables (it tells me)  how should i write the