This topic is locked

Searching

5/11/2005 3:48:44 AM
ASPRunnerPro General questions
T
The Capt author

I have several fields in my database which are check boxes for Yes/No showing that a member has joined for that particluar year.
I want to search the fields to show all records that have a check in the box for Yes for a particular year and list only those records for members who have joined. I will also need to run a report on records for No listing all members who did not join
If I put Yes or No in the search for a particular year I get no records found.
Can you help please.
All other types of searches work fine
TheCapt

Sergey Kornilov admin 5/11/2005

Hi,
if you use basic search choosing yes/no field name Equals 0 or 1.
Also you can set Edit as format as Checkbox on the Formatting tab in ASPRunner Pro for these fields and use Advanced search.

T
The Capt author 5/12/2005

Thanks. Worked a treat
The Capt