Conditional Sum MS Access
- Status: Closed
- Prize: $10
- Entries Received: 6
Contest Brief
0
down vote
favorite
I have a question. I have 2 queries
[ORDERS] [Products] [CUSTOMER] [QTY]
........1...............A...............X...............2
........2...............A...............Y...............3
........3...............B...............Z...............5
........4...............C...............X...............1
........5...............A...............P...............1
the second query
[ID_PROD] [Products] [QTY_AVAILABLE]
........1...............A...............5
........2...............B...............5
........3...............C...............0
........4...............D...............0
So, basically I have to find out which customer will not have his order completed.
It doesnt matter if I have to do it with a macro or query,
Please, contact me in order to explain you better.
I appreciate your help.
Recommended Skills
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!