2. ASPRunnerPro General questions
  3. [SOLVED]  Advanced Search page - Empty value
This topic is locked
[SOLVED]

 Advanced Search page - Empty value

 		10/2/2011 3:20:29 PM
ASPRunnerPro General questions
Y
 yairilan author

Hi,

In the Advanced Search page, when I have a regular text field, there are many option to choose like "Contains, Equal to, Between and empty

BUT, When one of the fields is a Lookup Dropdown box, There is only one option, without the Empty option.
My question is - How can a user search for all the records that are still empty, when there is a dropdown box?

( I've tried to change the field in the visual editor to be Text only for the Advanced Search Page, but it changes the Edit, and Add field as well... )
Thanks,

Yair
Y
 		yairilan author 10/11/2011

Anyone?
jadachDevClub member 10/11/2011

Here's what I do.
I use SQL Server for my database. Access should be the same.
In the Query Designer, click the SQL Tab.
Now find the field you are referring to (the one using a dropsown).
Directly under it add this: FieldName AS FieldNameSearch,

Use your actual field name of course.
So, it should look like this:
Select

ID,

FieldName,

FieldName AS FieldNameSearch,

OtherField,

etc

From TableName
Now in the Fields section of ASPR, use the new field as your search field.
Y
 		yairilan author 10/17/2011

Hi jadach,

Thank you very very much for your answer!

Yair