Conditional Sum MS Access

  • Tila: Closed
  • Palkinto: $10
  • Vastaanotetut työt: 6

Kilpailun tehtävänanto

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.

Suositellut taidot

Julkinen selvennystaulu

  • danielrinf
    danielrinf
    • 2 vuotta sitten

    cualquier cosa

    • 2 vuotta sitten
  • lucianoluca1983
    lucianoluca1983
    • 2 vuotta sitten

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

    • 2 vuotta sitten
  • piyushdpatel
    piyushdpatel
    • 2 vuotta sitten

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

    • 2 vuotta sitten
  • kishoreb4
    kishoreb4
    • 2 vuotta sitten

    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?

    • 2 vuotta sitten
    1. kishoreb4
      kishoreb4
      • 2 vuotta sitten

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

      • 2 vuotta sitten
    2. kishoreb4
      kishoreb4
      • 2 vuotta sitten

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

      • 2 vuotta sitten
  • nebivalaya
    nebivalaya
    • 2 vuotta sitten

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

    • 2 vuotta sitten
  • paricoto
    paricoto
    • 2 vuotta sitten

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

    • 2 vuotta sitten
    1. kenethwalters
      Kilpailun järjestäjä
      • 2 vuotta sitten

      the orders are complete when they have the products to ship

      • 2 vuotta sitten
  • bobycom
    bobycom
    • 2 vuotta sitten

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

    • 2 vuotta sitten
  • kishoreb4
    kishoreb4
    • 2 vuotta sitten

    Hi, Im interested in this contest.

    • 2 vuotta sitten

Näytä lisää kommentteja

Kuinka päästä alkuun kilpailuiden kanssa

  • Julkaise kilpailusi

    Julkaise kilpailusi Nopeaa ja helppoa

  • Vastaanota tonnikaupalla osallistumisia

    Vastaanota tonnikaupalla osallistumisia Ympäri maailmaa

  • Palkitse paras hakemus

    Palkitse paras hakemus Lataa tiedostot - helppoa!

Ilmoita kilpailu nyt tai liity tänään!