I have a database that has been running fine for years. When I change the
dates on the queries to pull the data for February, it is coming up blank on
one set and not on another. If I change the dates back to January, it again
pulls data fine. Is anyone else having problems with ...

I have two patient tables.  One has patients with a certain condition, and
the other has patients with a different codes.  Some patients have both
conditions (so they will appear in both tables), and I want to find those
patients who are only in the first table and not the second ...

I am trying to write a query that would allow me to calculate the proportion
of a specific value in a field against against the sum of all the values in
that field. In other words something like:
select balance / sum (balance) from table where account_type = 'Line of

I am creating a small database to collect labor information on a job by job
basis.  I will have the operators logging information into the database using
a barcode scanner.  The information collected will be:  Operator ID, Job
Number, Status (i.e., start or end).  The input form ...

I'm sure this will not be too advanced for someone but I'm lost with it, I'm
using Access 2000.
I have a table with almost 1 million records and 8 fields.
Field 1 is a primary key with an auto number.

Hi,
I want to create the following query:
SELECT [13].[Division , [13].[RMC Cust code], [13].[RMC Cust desc],
[13].[Budg code], [13].[Budg desc]

please help How can I capture result of this SQL in my Textbox(txt1.value):
SELECT Max([Seventh]+1) AS Expr1
FROM TBL7 INNER JOIN country ON TBL7.Country = country.[COUNTRY-NAME]
GROUP BY country.CCODE

I have a table, say tblItem, with a primekey. The second table, say
tblCustomer, contains the foreign key to the first table with a 1-to-many
relationship. That is for an item in tblItem, there may be one or more
entries in tblCustomer.

I'm doing a long conditional statement that checks if 2 fields have 0 or >0
values.  It must be a problem with the syntax I'm using.  Here's my code that
is erroring out:
Currently: iif( [TableE].[Sites] >0 and [TableE].[Subjects]=0,"Sites

I am using a query as a mail merge source. I have some e-mail address that
are duplicates and I want them to be maintained that way in the table. Is
there an expression I can use in the creteria of the query that says return
duplicate values only once.

I am hitting a brick wall!
I have been trying to "flatten" a Table generated by a Maketable query
based on a Crosstab query...
The reason behind it is to provide a Crosstab like form for users to