If Blank Select All

[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

 

[Evi]

See Allen Brownes Search Criteria.mdb on how to build up a search string
with the alternative of leaving everything blank.
http://allenbrowne.com/ser-62.html

 

[Duane Hookom]

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

 

[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.