View Full Version : One Field, Diff. Entries


gfcjr
03-16-2000, 01:21 PM
I need to make a report, count each Entry of the same field, but each entry might be different. example I have 50 records of one type and 50 records of an other type, in the same field. Now out of the 1st 50 records lets say 15 Applications came back, I want to show how many came back and how many was sent out, all on one report, But keep in mind that I also want to show the 2nd 50 records the same way on the same report. But maybe only 22 Applications came back.

dennyryan
03-20-2000, 05:36 AM
I'm not clear on your question but I'll answer the one that I can figure out.

I will assume that your field is something called Status where the values are "Sent" or "Returned". In a select query for your report you would have a calculated field like so:

Result: iif(Status = "Returned",1,0)

The Result column will now contain a count of the recors that were returned.

Denny