If Blank Select All

  • Thread starter Thread starter daveyboy300
  • Start date Start date
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
 
Please provide the SQL view of your report's record source and tell us which
control might be blank.
 
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.
 
Back
Top