Sum in query problem

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

?i,
I've a problem with SUM.
My first query is to give a numeric value to records with a unique Worker
ID. The worker ID is
selected via combo box & the field the combo value will sit in is a
secondary key. My first query
(qry_1) looks like this:
Worker AAA001:([Worker_ID]="AAA001")*-1
This is fine & gives me 1 for every time this worker's ID appears in the
field.

I know want to get a sum of the 1s. This new query looks like this:
Worker:AAA001
qry_1
Sum

When I try to run it a dialog box pops up Enter Parameter Value

The above approach works for getting sums from other queries eg gender but
not this one.

Any suggestions appreciated.

Grant
 
Grant

You've described a somewhat complex "how", as in "here's how I'm trying to
do something". Consider posting a bit more information about the "what" or
"why". If 'group readers better understand what you hope to accomplish,
they can offer alternate "how to's".
 
Back
Top