Almost finished with my Customer statement report ad I've ht a snag. Please see image for query that contains all the fields for a certain customer.
I'm trying to calculate the 30 days field to have it show the sum of all the records that is 30 - 59 days from the start date. The start date and end date is selected on a form which opens the report.
I have read about Switch function and IIF function but have no idea how they work or how to use them.