Conditional Sum MS Access

Status: Closed
Prêmio: $10
Inscrições Recebidas: 6

Síntese do concurso

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.

Habilidades Recomendadas

Lance um Concurso Como Este

Painel de Comentários

danielrinf
- 8 anos atrás
cualquier cosa
- 8 anos atrás
lucianoluca1983
- 8 anos atrás
Hello, I wanna know if the visibility is ok in the image that I posted.
- 8 anos atrás
piyushdpatel
- 8 anos atrás
i can do with simple query or if you want it is also possible from macro
- 8 anos atrás
kishoreb4
- 8 anos atrás
Can you please elaborate on the problem statement. Does a customer buys only one product.?How should we distribute the quantity available Based on the time when an order is placed or the quantity is he/she purchasing?
- 8 anos atrás
Ver mais 1 mensagem
1. kishoreb4
  - 8 anos atrás
  Ok Got it..And I'm not sure how contests work... Do you want me to place my code here or anything else?
  - 8 anos atrás
2. kishoreb4
  - 8 anos atrás
  Hi I have uploaded my code along with description. I hope that would solve your problem. Please let me know your feedback.
  - 8 anos atrás
nebivalaya
- 8 anos atrás
Hello! Please contact me, I'll try to help you.
- 8 anos atrás
paricoto
- 8 anos atrás
How do you identify completed orders? Is there a flag "completed = YES" or something similar?
- 8 anos atrás
1. Proprietário do Concurso
  - 8 anos atrás
  the orders are complete when they have the products to ship
  - 8 anos atrás
bobycom
- 8 anos atrás
Don't you think that $5 CAD is too low prize for this contest? The other $5 will go to freelancer.com.
- 8 anos atrás
kishoreb4
- 8 anos atrás
Hi, Im interested in this contest.
- 8 anos atrás