Monday, 14 March 2011

Sum in reports

Easy - just do a textbox with =sum(nameofthefield)


make sure it's in the Report Footer - not the Page Footer!

Searching for a blank field

Sometimes you want to search for fields which have been left blank - say you've put the date a job was completed on.

All you do is add the criteria of Is Null (the space is important!!!) and it'll do it.

Personally I'd tend to suggest using a Yes/No field to record if it's been paid for this sort of thing, but sometimes client needs mean you need to record the actual date.