I hope someone can help me out with this. I have a table that has some fields named SpecialNumber, BuyOrSell, TranType, Amount. Each SpecialNumber might be in the table once, or multiple times. Can a query be written that shows how many times each SpecialNumber is in the table?
If I have the following values in the table:
12345, 'Buy', 'Cash', $100.00
11111, 'Sell', 'Credit', $89.00
33333, 'Sell', 'Credit', $44.00
22222, 'Buy', 'Credit', $55.00
22222, 'Sell', 'Cash', $22.00
I need to know that 12345 is counted as once, 11111 is counted as once 33333 is counted as once, and that 22222 is counted as twice. And if possible just show the ones for when the count is more than once. Is this possible? If so, will someone give me a hand with this? PLEASE