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

Please don't post the same question multiple times.