I'm trying to generate a report, listing all the clients in a certain table, leaving out all those who's 'Package Total' field is blank.
So my report is a list of only those clients who have something in that field (Only confirmed clients have anything in that field, so it only lists confirmed clients and not enquiries)
And I'd like the bottom of the report to show a sum of All the 'Package Total' fields added together.
I'm really new to this. I've managed to use the report wizard to show a columnar view, but right now it's showing every entry in my table, I'd like to know how to filter it to leave out those with that field blank.
All Google results I've found tell me to add entries to the 'Filter' entry under properties, but I can't see one!