I have a table with the following in MS access 2007(don’tknow if this has to be done in a SQL statement).
<tbody>
</tbody> Since they are groupby the bag number and showing the max date. I would like to know how to createa query that would give the result of Bag 1. So if a bag has Candy OR nutsonly show bag 1.
And another query to show if a bag has NO candy or nuts showBag2
Thank you very much for your help in advance.
Bag# | Item | Date |
1 | Pears | 5/3/13 |
1 | Apples | 5/3/13 |
1 | Oranges | 5/3/13 |
1 | Bananas | 5/3/13 |
1 | Lettuce | 5/3/13 |
1 | Milk | 5/3/13 |
2 | Pears<o></o> | 5/3/13 |
2 | Apples <o></o> | 5/3/13 |
2 | Oranges<o></o> | 5/3/13 |
2 | Bananas<o></o> | 5/3/13 |
2 | nuts<o></o> | 5/3/13 |
2 | Candy | 5/3/13 |
2 | Milk | 5/3/13 |
And another query to show if a bag has NO candy or nuts showBag2
Thank you very much for your help in advance.