linked multiple tables/queries in SQL

hboisteau

Registered User.
Local time
Today, 07:03
Joined
Jun 5, 2012
Messages
14
Hello,
I already post a similar message in this forum at the design but I think the message should be deposit here.
I think my problem lies in the writing of a SQL query.
I attached two pictures, which I think will be much more explicit than words.
Thank you in advance.
HB
 

Attachments

  • base.jpg
    base.jpg
    95.7 KB · Views: 108
  • Sans titre.jpg
    Sans titre.jpg
    100.9 KB · Views: 117
Try to describe WHAT you are trying to do.
 
Hi,
I try to calculate the last column of the excel sheet.
I want to determine the amount that should be shown on the display.
HB
 
So you want to have a field that does running subtotals based on the NOMPROGRESSIF value. I somewhat get what you're looking to do (although I'm not sure how the jackpot table fits into the calculation).

I can tell you that you won't be able to get a query to generate this in this order. You can probably do it in conjunction with a report, but not a query by itself.
 
table "misedepartprog" is fed by a form, the day of the start-up of the progressive.
table "gainsprogressifs" is also a form supplied by the date or the jackpot has been won.
The calculation to determine the value should be displayed:
(montantinitial + Increment Prog + Increment Hidden) if it has not been won.
((montantinitial + Increment Prog + Increment Hidden) - montantgagné + montantinitial) it was won.
thank you again
HB
 

Users who are viewing this thread

Back
Top Bottom