Totals Query

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?
 
M

[MVP] S. Clark

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Adding data to MS Access from csv file 0
query field names changing to expr#: 8
Preventing duplicate entries with an Append Query 3
Append only new records/entire record makes unique identifier 4
Cross Tab Query 1
linked worksheet connection error 5
Make Table query 2

Top