Snowflake68
Registered User.
- Local time
- Today, 23:41
- Joined
- May 28, 2014
- Messages
- 452
I need to create a bespoke reporting tool that will allow the user to select multiple options from a combo box but want to avoid using the built in multi valued field.
I have a record set with an ID, a status and various other pieces of information (such as date created, created by, quote value etc) surrounding quotes raised in a system that I have built.
I need to built a report where the users selects dates (which I have already sorted) but also the status from a drop down box. I need to be able to allow the user to select multiple statuses. The statuses I have are indicated by a single character. Q, C, B, I or F.
What is the best way to do this so that the user is able to specify the selected status using a parameter in a query.
Any suggestions would be very grateful.
I have a record set with an ID, a status and various other pieces of information (such as date created, created by, quote value etc) surrounding quotes raised in a system that I have built.
I need to built a report where the users selects dates (which I have already sorted) but also the status from a drop down box. I need to be able to allow the user to select multiple statuses. The statuses I have are indicated by a single character. Q, C, B, I or F.
What is the best way to do this so that the user is able to specify the selected status using a parameter in a query.
Any suggestions would be very grateful.