Calculating in reports



i'm pulling 12 fields from a query 6 of which have names
of people ie field1 jane doe, field2 drew smith, field3
jim doe, field4 jack smith, field5 tom smith, and field6
diane marie. If the field is blank i want it to be 0 and
if it has a name in it i want it to be 1 thus i can count
how many groups i have. I thought i might need to do this
on the report open event and do a loop but i am not sure.
Can anyone help me?

Fons Ponsioen

You could do this with
all on one line this will give you a count of the entries
per record
Hope this helps.

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