Search results

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

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

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

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

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