Easy - just do a textbox with =sum(nameofthefield)
BUT
make sure it's in the Report Footer - not the Page Footer!
Monday, 14 March 2011
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.
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.
There's all sorts of good stuff here, mainly aiming at my Applied A Level classes.