Totals Query

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have an append query that counts the number of records
in a table, then appends to 2 fields, [Name] and
[CountofName]. The user is prompted for a 'Name', which is
used as the query's criteria. If a record exists with
that 'Name', the query appends with the number of records.
If not, then nothing gets appended to the new table. How
can I make it append with the 'Name' and 0
for 'CountofName', if no records exist in the original
table?
 
An Outer Join will show ALL records from one table, as well as matching data
from the other.

Make it the basis of your parameter query.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top