linked multiple tables/queries in SQL

[hboisteau]

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

 

[jdraw]

Try to describe WHAT you are trying to do.

 

[hboisteau]

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

 

[Cerial]

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.

 

[hboisteau]

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