Count total values for specific field

Status
Not open for further replies.

daherb

Registered User.
Local time
Today, 17:43
Joined
Sep 14, 2005
Messages
66
In my report i have a number of enquiry entries that have been authorised.

To specify whether this has happened the database has a yes/no format in the enquiries table.

I have included this field in the report but in the summary of the report for each customer i want to calculate and display the sum of entries authorised.

I know that Count(*) counts all the records in a report and displays the results but can you specify what you want to be calculated. i was thinking along the lines of Count([fieldname] where [fieldname]=yes) but it doesn't work as i was pretty sure it wouldn't as it was a complete guess.

Can it be done and how?????

i have now tried =Sum([fieldname]) which does the caluculation but puts the figure as a minus number, is there anyway to make this a positive number
 
Last edited:
Please don't post the same question multiple times.
 
Status
Not open for further replies.

Users who are viewing this thread

Back
Top Bottom