Counting Problems

[MikeP]

I'm trying to count multiple items for a report. Each count is a seperate
query. When I tie them to the record souce for the report the items m
counting will mulitply each other and display that number in all fields.

What in the world am i doing wrong!?!?!

Thanks

 

[Tom Wickerath]

Hi Mike,

You can add a text box to a report with control source set: =1, and set the
Running Sum property for this text box to either Over All or Over Group,
whichever is appropriate for you situation.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________