Recent content by hboisteau

Hello, with the help of the forum I already have several things realize this request below. SELECT Format([Date],"mm-dd") AS Jour, Sum(IIf(Year([Date])=2009,[Somme De Coin In Mad],0)) AS [Coin In Mad 2009], Sum(IIf(Year([Date])=2010,[Somme De Coin In Mad],0)) AS [Coin In Mad 2010]...

Thanks you very much, HB

Hi, I try to add the same number on a query, I have many line and I want add the same number for all of lines at the last colone on my query. Thanks in advance. HB

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...

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

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

Morning, I'm trying to rethink my basic view in order to follow the progression of my "progressive displays". In fact I work in a casino and one part of my job I need to check that the display is correct. How to increase the value of the progressive, each time a customer plays on a machine...

hi, Please I need more precision on my problem. I have to do a meter management of slot machines and for that I read the daily meters, unfortunately it may be that we were wrong about entering meter (reversing digits) and also for technical reasons that meters be provided to zero. In both cases...

Yes I forgot to say that this only applies for some slots. For the rest I do not really understand what you mean. You can specify. Thank you again. HB

Morning, I'm still thinking about my database creation and I really struggle to see how. Let me explain, I have one table or daily basis I write the meters of slot machines. this table looks like this: Id Slots Date Meter1 Meter2 1 1000 01/01/12 120 450 2...

Thanks, this code working, but I need more information inside the MsgBox. For all records on the table you find the Date and the Number of slots. I'm looking for an similar MsgBox: "Slots 1045 negative numbers on the 01/01/12" Thanks in advance. HB

Thanks, but one more question, where I push this code? Macro? Thanks again, HB

Thanks for your answer, but I have a new question, I made a mistake is not for the table but it's for the query. Where I push the code on this query. Thanks in advance. HB

Hi everybody, I import a large amount of data in a table for convenience and fast. Thereafter I create a query and then a new table to compare the data. After that, I would like to have a message saying that I have negative values ​​in my table. To be more simple, I seek to control the way a...