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
Module and query modified
Tester-Adhoc-2.zip