Report "WHERE" not working

[rsearing]

I am new - please go easy - and very confused why this isn't working. I have a report that works great when I click on the report "New Parents Billing" It shows both parents - and all their children (it's a daycare center app). The problem is - when I run the report from the form I created "f_calculate bill" It's *supposed* to work so that if you don't click on a parent from the dropdown - it will query all parents - or if you click on a specific parent and "view report" - it will choose that individual. Problem is when I click on "Mark Sutton" - he doesn't show up - not even his ID - however, the query that the report is based upon ("query4") does show the record (id is 2).

I have uploaded the 2 database files at:

ftp://www.kofc1913.org/GregoryDayCare.mdb
ftp://www.kofc1913.org/GregoryDayCare_be.mdb

I am thoroughly confused - please help.

Sincerely,
Rob

 

[rsearing]

Fixed link - it's now a zip file at:

www.kofc1913.org/daycare.zip

 

[rsearing]

Figured it out. Basically - the filter was also calculating dates. Although I now had parentId's - in the case of Mark - I didn't ahve a date - so I changed my WhereClause to include date returns with NULL.