I am trying to set up a query/report for exam due dates.  So, for instance,
individuals should have a dental exam every 6 months.  I would like to run a
parameter query that will tell me all of the dental exams that are due for a
given month based on the last visit date.  ...

I have a simple expression query that I just can not get.
I have a table called discs, in this table there is a logical field (yes,no)
called clubs. I want to be able to use the expression builder so that if the
club value equals yes then the Charge(name of the expression I am ...

I had a question about a count query. I have parent records (literally
about parents) that include a date when the parent came in for the
first appt. Based on the number (which is defined as an integer), it
goes into 1 of 3 buckets -- greater than or equal to 0 and less than or

I have a text field. How can I find records with only alphabetic characters
in it?
Thanks

I need to calculate a field in query which uses two values in two fields
(field1, field2) to run a query, then sum and average all the values in two
other fields (field3, field4) in the resulting query, then display that
average in the calculated field.  How can I do that?

I have the following expression
GGWPERSQFT: IIf(IsNull([SALEPRIC]),[LSPRC]/[APPGSQFT],[SALEPRIC]/[APPGSQFT])
but I want to add:
if [appgsqft] is zero, then null

I am trying to run a query on expirations of certifications of employees.
My query runs and checks 7 dates to see if they are expiring within the next
30 days. However, the query shows all of the other dates that are not
expriing.

When we run a query, display title:
Enter Parameter Value
Is it possible to change this title?
Thanks in advance.

Just curious -- why is it that when I sum up check boxes on a record,
the value in the query is Yes/No (even though I can click on the value
and see the total.) Even when I try an Abs on it, I get a Yes/No. Is
there a way around this?

I am building a query to return all records between dates selected
by the user.
When I use the following code to build my query, the date selection
works correctly:

Can I make something like this:
column1 - column 2
but only for some grouped variables
For example: Substract Debt - Payment for each client in NYC, then in CHI ,

I'm trying to create a database that will run a match against a text file
that I get everyday.  I want to be able to run the text file information
against my database TblSensitiveCustomer and show only the ones that match.  
Tables are called TblSensitiveCustomer, TblDailyimport, ...

I'm using Access and VB to make a program:
I was wondering how to make an SQL query that filters a recordset for
column A given that the corresponding Column B contains a "nothing"
(null, empty... whatever).

I have two tables: computer, software with 1 to many relation on 'serial'
'computer' table fields: serial, name (first 6 character identify room)
'software' table fields: serial, description (software name)
how to construct a query that give me software (description) count by room?

The following query, instead of adding the numbers 0, 0, and 1 to finish the
calculation in the last column, is instead concatenating them to come up with
the number 001. Aaarrrgggh!
SELECT FMS_HELOC_crosstab.EmpID, FormatNumber(Nz([Mortgage],0),0) AS