Sorting data within List Box on Form to Work with Report (1 Viewer)

[MissCLuvr]

I am having a problem with a list box where the user chooses several options to bring back data onto a report. My problem is that if the user selects K-1 (kindergarten to first grade) it only chooses K-1 information. What I want it to return is K-1 plus all first grade listings as well. If anyone understands this dillema please help me. If you need more details let me know. Thank you in advance....by the way this is needed by May 20.

M. R.

 

[ALF3911]

I generally solve this problem by creating a data table that will equate K-1 to K, 1, and K-1. Then I join this table in my search query.

 

[MissCLuvr]

I created the data table as Grade Level with only K, 1,... to connect to my Grade Levels table which include K-1, K-2... and I added it to the query so that the information will be returned but it did not work when I tried to connect it to the Report. Can you tell me how you would write that query so that the report will give me what I need.

Thanks for your help.