View Single Post
  #1  
Old July 26th, 2007, 02:22 PM posted to microsoft.public.access.reports
Rockn
external usenet poster
 
Posts: 48
Default Report critera - Date Range

I have an unbound form that is used to set the criteria for a report. I have
date fields for a start date and an end date. I want the report to return
all records when the date fields are empty and cannot get it to work in VBA.
I have it working when the date fields are populated, but when they are emty
I get the error "Invalid Use of Null"

I have tried a conditional statement to test for Null in both fields, but I
get the same results.

Seems like it should be straight forward, but I am probably looking at it
too hard.

Thanks