How do I get all results?

B

BJ.Kline

On my search page I used the Database Results wizard to populate a
drop down box. I have 3 things a user can search by; Location, Shift,
and Position; each of these are in a separate drop down box . I
created a custom query in the Wizard to do a Select Distinct on the
field. This works as I want but I need to able to show all the results
when a user selects all. For example if they chose ALL Locations, 1st
Shift, and a Position of Nurse, they should see all 1st shift Nurse
positions in the database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to Combine reports to's to a single box? 0
How to link seperated documnet into a single document 0
Dynamic Naming of Form Button 3
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Add all values item to a date field query in a drop down box 3
Drop down box behavior 2
Submit form results to another form 2
results form input sent to another form 1

Top