[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

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
0
deefel
Asked:
deefel
1 Solution
 
hnasrCommented:
GoCarts                       GoCarts:  01, 016 == 04,016

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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now