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
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:
