MS access changes vertical column into rows

This is part 2 to a question I received help on with the above "Title".  The module appears to be working ok but now my results are pulling incorrectly.

Query runs off table called tblScott2, Query name:  Q_Test1
At the prompt I am looking for *Mar* (to get any activity for any ID that happened in March ~ used wildcard because user not consistent on how they enter the DSC.

When I select “*Mar* ~ I should get
Tublight                       Tublight: 01, 05
BallLight                       BallLight: 01, 09
GoCarts                       GoCarts:  01, 016
SwitchBreakers      SwitchBreakers: 016
HoldingTub      HoldingTub: 06, 01

When I select "*Mar*" ~ I get
BallLight                       BallLight:  01, 09
GoCarts                       GoCarts:  04, 016
HoldingTub      HoldingTub:  01, 06, 016
SwitchBreakers      SwitchBreakers:  01, 012, 016
TubLight                        TubLight:  01, 05, 016

There is an extra page in "Tublight"; 2 extra pages in "SwitchBreakers";  and an extra page in HoldingTub.
Can't see why those extra pages are picking up.  I have attached the database.
Tester-Adhoc.zip
deefelAsked:
Who is Participating?
 
hnasrConnect With a Mentor Commented:
GoCarts                       GoCarts:  01, 016 == 04,016

Module and query modified
Tester-Adhoc-2.zip
0
 
deefelAuthor Commented:
Worked perfectly.  thanks
0
All Courses

From novice to tech pro — start learning today.