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.
Solved
MS access changes vertical column into rows
Posted on 2014-04-14
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses
Course of the Month12 days, 17 hours left to enroll
650 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.