If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Select query issue

Hi,

I am making a form that when data is input it uses that data as criteria in a query and gives a report that is based on that query. However, when nothing is entered into say the "name" field then no results appear. Obviously this is because it is searching for blank name fields but not coming up with any thus no results to display. Is there a way around this, so that when no data is entered in the "Name" field then ALL the names are given in the report.

If you currently have blank data in a field (mixed with non-blank data) and you want to setup criteria in a query based upon a 'search' type value in an unbound field on a form (so it shows all data if the search field is blank), there is a little trick you can use in your query: