Pop-Up To Select Query Filter

[djruni]

For the source query of my report, I have specified a value for the 'criteria' of one of the fields. For ex., the Assigned To field is filtered to display items assigned to a particular name.

Rather than pre-define this value directly in the query, is there a way to have a pop-up appear prompting for this value when the report is ran?

So, when I double-click on my report to view it, I get a pop-up asking for the 'Assigned To' and I can enter the desired value.

Will greatly appreciate any help - thanks!

Tarun

 

[Michael J Ross]

In your query criteria under Assigned To field put [Enter Assigned To], this will prompt you each time you run the report.

 

[djruni]

Thanks! That was simple. New question though, some of the fields in my database are entered as text, but stored as numbers. For example, I have an Assigned To name as "Manhattan Associates" entered by users in the database. But it is stores as a value of "1138297884".

So, in the pop up I must enter the numeric value rather than the text, which is uknown to the user. I can Create another field in the query and do a pop-up on that, but how to transalte the numeric value to text form???

 

[djruni]

Also, is it possible to select multiple values via the pop up? For example, I want to see items assigned to more than just one specific name, perhaps two or three names. Can I specify multiple values via the pop up?

 

[Michael J Ross]

Thanks! That was simple. New question though, some of the fields in my database are entered as text, but stored as numbers. For example, I have an Assigned To name as "Manhattan Associates" entered by users in the database. But it is stores as a value of "1138297884".

So, in the pop up I must enter the numeric value rather than the text, which is uknown to the user. I can Create another field in the query and do a pop-up on that, but how to transalte the numeric value to text form???

Do you have some form of look up table to convert the numbers to names? If so you should bring this in to the query and join it to your main table, and search on the name from the look up table.

 

[Michael J Ross]

Also, is it possible to select multiple values via the pop up? For example, I want to see items assigned to more than just one specific name, perhaps two or three names. Can I specify multiple values via the pop up?

No you can't, you would need to use a form with text boxes to enter your criteria in or a list box to select names from.

Do a search in the queries forum on query using forms, there should be loads of examples of how to do it.