Hi
I have a query that depends on the input (several parameters) from a form. The form has a list object that shows the results of the query. For example, when I type in "s" in last name and "b" in city, it shows everybody whose last name starts with s and city name that starts with b. The problem is that it excludes all the records with blank cells in either last name or first name or city. In another words, the list is already pre-filtered with records that contain all three fields (city and first name and last name). For example, the record (Last name: Mosby, First name: Ted, City = blank) will be excluded from getting displayed because it contains no characters. Can someone help me out with this issue? I would like to include those people on the search even though their city is not entered in the table. With the query parameter empty, I would like to show a very raw list (a list that is not filtered at all).
The Query is built as follow:
The criteria for the field "Last Name" is
Like [forms]![simform].[lastnamesearch] & "*"
The criteria for the field "First name" is
Like [forms]![simform].[firstnamesearch] & "*"
The criteria for the field "City" is
Like [forms]![simform].[city] & "*"
I have a query that depends on the input (several parameters) from a form. The form has a list object that shows the results of the query. For example, when I type in "s" in last name and "b" in city, it shows everybody whose last name starts with s and city name that starts with b. The problem is that it excludes all the records with blank cells in either last name or first name or city. In another words, the list is already pre-filtered with records that contain all three fields (city and first name and last name). For example, the record (Last name: Mosby, First name: Ted, City = blank) will be excluded from getting displayed because it contains no characters. Can someone help me out with this issue? I would like to include those people on the search even though their city is not entered in the table. With the query parameter empty, I would like to show a very raw list (a list that is not filtered at all).
The Query is built as follow:
The criteria for the field "Last Name" is
Like [forms]![simform].[lastnamesearch] & "*"
The criteria for the field "First name" is
Like [forms]![simform].[firstnamesearch] & "*"
The criteria for the field "City" is
Like [forms]![simform].[city] & "*"