Filter QueueName

[aftabn10]

Hi, I am trying to create a report in MS Access and I have a field called QueueName. This consists of 3000 queues so i would like to add a filter so that I can filter down to any queue that I require to see on the report.

I have tried to use a listbox but that doesnt work. Could somebody please help?

 

[DCrake]

In the design of the underlying report query go to properties and add a parameter that will prompt the user for the queuename.

David

 

[aftabn10]

Thanks for your reply. Is their anyway i can add a filter so that the user can see the report but filter the queuename on the report?

For Example:

Queue Name (filter)

Queue 1
Queue 2

 

[DCrake]

Don't quite follow what you mean. Are you suggesting that the users sees the report first then drills down to a specific queue?

David

 

[aftabn10]

David,

Thats correct quite similar to when you viewing data in Excel where an AutoFilter would allow you to analyse the data that you have and pick what queues you would like to see.

Thanks for your help.

 

[DCrake]

The only way to achive this is by using the snapshot viewer control to bring the whole report into the form detail section then in the form header have a combo box that when updated applies a filter to the report. Never tried it but I know it is possible.

David

 

[aftabn10]

Thanks David, I will try and let you know how i get on.