If Blank Select All

D

daveyboy300

I have a query that picks up its filter from unbound fields on a search form.
can i set it up so that if the unbound field is blank the query will report
on all fields.

secenario is producing account reports filtered by account number, and i
want if blank report all

thanks
dave
 
D

Duane Hookom

Please provide the SQL view of your report's record source and tell us which
control might be blank.
 
D

daveyboy300

Sorry may not of explained my self very well. The filter within the query is
"[Forms]![Transactions By Account]![AccountNumber]" Specified form is only a
search form and is not related to my tables in any way. I want the database
to select all results if i leave this field blank.
 
Top