September 6, 2014 at 3:30 pm
Hello
I need help on how to compile a report based on barcode data. In my table, I have TRANS_DATE, BARCODE_NUM, NET_SALES, etc
For each receipt, there can be one or more coupons used. Were trying to determine how many times COUPON 1 was used together with COUPON 45 or COUPON 100, etc.
Thank you in advance.
G
September 6, 2014 at 3:57 pm
Hard to really provide and answer with so little information. Perhaps a query selecting COUPON 1 combined with an exists subquery checking for the existence of the same order(s) with COUPON 45 or COUPON 100, etc. selected. Or, perhaps, this should be turned around. Hard to say without knowing more about the requirements.
May I suggest you read the first article I have linked below in my signature block regarding asking for help. It will walk you through the things you should post and how to post them to get the best possible answer to your question. In addition, you will get tested code in return, not just random shots in the dark that may not be helpful at all.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply