help with count

  • Thread starter Thread starter Loretta
  • Start date Start date
L

Loretta

I need to do a count in a query or form that I can use for further
calculations. I have the query done but it counts the ID and then multiplys
it by the count. So if I have three records it reports it as 9, 2 as 4, 4 as
12.
 
I need to do a count in a query or form that I can use for further
calculations. I have the query done but it counts the ID and then multiplys
it by the count. So if I have three records it reports it as 9, 2 as 4, 4 as
12.
Click to expand...

No way to tell what's happening without seeing the query SQL.
Post it.
 
You must log in or register to reply here.

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

Help with count in query 3
Count in a query 7
Sum records in column continued...multiply count by 5 --------M--- 2
Distinct Count in Crosstab 1
multiple counts, same calculated field, different parameters 6
Access Dcount (multiple criteria) 3
Counting Records Delima 5
Design and layout for Order Analysis? 5

Back
Top