total Count

[Alaska1]

I need to have the query below count the number of Packet ID and the number of Data Entry Errors



Select [Packet ID], DataEntry1 from DataEntryErrors
WHERE DataEntry1 is Not Null
UNION ALL
Select [Packet ID], DataEntry2 from DataEntryErrors
WHERE DataEntry2 is Not Null
UNION ALL Select [Packet ID], DataEntry3 from DataEntryErrors
WHERE DataEntry3 is Not Null;

Example
Packed ID 11

Data Entry Errors
time missing 5
Incorrect entry 3
Incorrect Job Number 3

Any suggestions?

[ajetrumpet]

alaska,

are these fields in one table? it looks like it.

if they are, do you really need a count in the actual query? most counting is done dynamcially, when needed, with domain functions. queries don't really need to produce aggregations in many situations, because the dynamic alternative is always available via built in functions or code.

for instance, if you need this count on a form or report, simply use DCOUNT(), with or without conditions in a control or some other object. DONE.

[Alaska1]

Thank you I will do the count on the report. Appreciate your help