Conditional Sum MS Access

  • Status: Closed
  • Præmier: $10
  • Modtagne indlæg: 6

Konkurrence Instruktioner

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.

Anbefalede Evner

Bedste indlæg fra denne konkurrence

Se flere indlæg

Offentlig Præciserings Opslagstavle

  • danielrinf
    danielrinf
    • 3 years ago

    cualquier cosa

    • 3 years ago
  • lucianoluca1983
    lucianoluca1983
    • 3 years ago

    Hello, I wanna know if the visibility is ok in the image that I posted.

    • 3 years ago
  • piyushdpatel
    piyushdpatel
    • 3 years ago

    i can do with simple query or if you want it is also possible from macro

    • 3 years ago
  • kishoreb4
    kishoreb4
    • 3 years ago

    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?

    • 3 years ago
    1. kishoreb4
      kishoreb4
      • 3 years ago

      Ok Got it..And I'm not sure how contests work... Do you want me to place my code here or anything else?

      • 3 years ago
    2. kishoreb4
      kishoreb4
      • 3 years ago

      Hi I have uploaded my code along with description. I hope that would solve your problem. Please let me know your feedback.

      • 3 years ago
  • nebivalaya
    nebivalaya
    • 3 years ago

    Hello! Please contact me, I'll try to help you.

    • 3 years ago
  • paricoto
    paricoto
    • 3 years ago

    How do you identify completed orders? Is there a flag "completed = YES" or something similar?

    • 3 years ago
    1. kenethwalters
      Konkurrenceafholder
      • 3 years ago

      the orders are complete when they have the products to ship

      • 3 years ago
  • bobycom
    bobycom
    • 3 years ago

    Don't you think that $5 CAD is too low prize for this contest? The other $5 will go to freelancer.com.

    • 3 years ago
  • kishoreb4
    kishoreb4
    • 3 years ago

    Hi, Im interested in this contest.

    • 3 years ago

Vis flere kommentarer

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Tildel det bedste indlæg

    Tildel det bedste indlæg Download filerne - Nemt!

Opret en Konkurrence Nu eller slut dig til os i dag!