Hi
New to Access, I was wondering if there is an easy way to return multiple vales on a query,
for example, I need to return data from column B for multiple values in column A
So I need to search for 2MA007
and 2MA020
and find information for both
Column A |
Column B |
2MA007 |
007 Appt Card 50pc Harmony |
2MA010 |
(D) 010 Appt Card 50pc Tranquil |
2MA011 |
011 Appt Card 50pc Sexy |
2MA019 |
019 Appt Card 50pc Rose |
2MA020 |
020 Appt Card 50pc Nat French |
2MA021 |
021 Appt Card 50pc City Chic |
2MA023 |
023 Appt Card 50pc Caresse |
2MA031 |
031 Appt Card 50pc Pearls |
2MA033 |
033 Appt Card 50pc Eden |
2MA035 |
035 Appt Card 50pc Pasha Red |
2MA039 |
039 Appt Card 50pc Oasis |
2MA044 |
044 Appt Card 50pc Red Rose |
2MA045 |
045 Appt Card 50pc Massage |
2MA046 |
046 Appt Card 50pc Spa Massage |
2MA047 |
047 Appt Card 50pc Lilly
|
I appreciate the help, thanks