I have ~30 small tables. From these tables I need to count the number of
records which match particular criteria and update a main table.
For example, the small table for Report X contains account numbers in one
column and several possible area codes in another column. (One ...

Why does the SQL below return accurate data for the COUNT portion for
specific date range, but for the percentage portion, it divides the accurate
COUNT by the total from the entire table instead of the total for the date
range?

(This is a new post to continue an old thread, by the same name.)
Thanks to the help I've rcv'd so far, Ive gotten to this point.
My current code is:
SELECT Format(INVC_DETAIL.INVOICE_DATE, "mmm,\ yy"),

can anyone send me the code to use the result of a count query in an
IF statement. i basically want it to be like IF count result = 1 THEN
open form swimmers ELSE open form error. many thanks michael

I have 2 tables with a one-to-many relationship. I would like to create a
query that shows only those records in the main table (the "one" part in the
relationship) that DO NOT have matching records in the other.
Thanks in advance,

(This is a new post to continue an old thread)
Thanks to the help I've rcv'd so far, Ive gotten to this point.
My current code is:
SELECT Format(INVC_DETAIL.INVOICE_DATE, "mmm,\ yy"),

I have to add about 1,000 records into my database incrementing the number.
Unfortunately the field is a text field. For example the value is 1G200. I
have to make 1,000 more records incrementing the 200 by 1. Is there an easy
way to do this?

I have created a Self Join Query:
SELECT DISTINCT A.txtLoanNo, A.intDR, A.intActExp/B.ActSum AS Perc
FROM tblDR AS A INNER JOIN
(SELECT txtLoanNo, Year(dteBegin) AS BgtYr, Sum(intActExp) AS ActSum

In my datasheet view I have a column with text and quotations around it.  
Example
field: Customer
"text"

I am trying to join two tables together based on a field.  It is text in one
field and numeric in another.  I cannot change the format of either but I
still want to join them.  Is there a way around this?
Chuck

I am trying to trim off the spaces in a text field.  I started a make take
query and insert expr:Rtrim([item]) but when I run the query I gets errors.
"undefined function rtrim in expression".  What I am doing wrong?

sorry if this question is a tad bit lame, but I ran out of practice re
SQL and and can't seem to solve this on my own.
Products
----------------------------------------------------

Does anyone know of a better way to write this?  It's a formula in a query
which DOES give me the right results, but seems like I'm taking a very long
way.
LDL_Goal: IIf([DiabetesRF]=1 And [CHD or Equ]=1,70,IIf([DiabetesRF]=0 And

Hi,
Please if any one can help me, I need to calculate the Next_Scheduled_Date
according to the Frequency(that depend on the months-1 month, 2 months, 3
months...) and the Scheduled_Date(that its date for exm-1/2/2007). I need

I am trying to do a select query with criteria to find certain characters.
These characters include * # ?.
I want to find accounts with 123#456, or 123*456, or 123?456
I need to write this into an sql statement