T
Tad71
Guest
I have somewhat limited experience with Access. I am trying to do 2 things in a form that I'm using to select report criteria:
1. I need a multi-select listbox to be used as query criteria for my report. I have searched online and found only partial explanations. I am not a VBA dummy, but a step-by-step explanation for dummies would be greatly appreciated.
To complicate further, the listbox should have 2 columns representing Policy_Num and Significance fields, but the report/query is only concerned with Policy_Num.
The listbox should also either contain a selection for ALL, or if there's no selection (Is Null) will return all records for that field.
2. I have a numeric field that I want to query w/ 4 possible choices in a combo box. i.e. 0-350, 351-999, 1000-Max, All Records. How do I make these the selection choices in the combo box, and have the query actually pull "Between 0 AND 350" etc?
I'm asking a lot here, as I need a solution asap to meet a deadline. Help would be greatly appreciated!!
~Tad
1. I need a multi-select listbox to be used as query criteria for my report. I have searched online and found only partial explanations. I am not a VBA dummy, but a step-by-step explanation for dummies would be greatly appreciated.
To complicate further, the listbox should have 2 columns representing Policy_Num and Significance fields, but the report/query is only concerned with Policy_Num.
The listbox should also either contain a selection for ALL, or if there's no selection (Is Null) will return all records for that field.
2. I have a numeric field that I want to query w/ 4 possible choices in a combo box. i.e. 0-350, 351-999, 1000-Max, All Records. How do I make these the selection choices in the combo box, and have the query actually pull "Between 0 AND 350" etc?
I'm asking a lot here, as I need a solution asap to meet a deadline. Help would be greatly appreciated!!
~Tad
