Solved

MS access changes vertical column into rows

Posted on 2014-04-14
2
213 Views
Last Modified: 2014-04-29
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
Comment
Question by:deefel
2 Comments
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 40000768
GoCarts                       GoCarts:  01, 016 == 04,016

Module and query modified
Tester-Adhoc-2.zip
0
 

Author Closing Comment

by:deefel
ID: 40030200
Worked perfectly.  thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now