Recent content by Fred

Hello.... See my image with Access information...Access 2003 will resolve it? Thanks!

Hello boblarson!! Perfect, I changed regional settings to English(United States), and I saw the correct result. Is a bug? My default is: Português ( Brasil ) Thanks!!

Hello Brian! You will see the result of your file... in my machine with access 2000. See attached image...You said that this example run 100% in your machine, with perfect values in running sum column...the concluison is ... there is somethig strange in my machine or access related...

Hi Brianwarnock! I changed table Fixed, 2 decimal places...As you can see in my example...but nothing different...The result 42,80, in 'running sum' column appears 42,00 Please, someone can take my attached example, and give some information about it ? Thanks!!

Please, Paulo JR, can you modify my Attached improved.mdb ? I inserted Fixed and 2 decimal places in 'running sum' column... But as you can see the RunningSum column is not correct: the correct value should be 42,8 , 77,8 .... and not 42,0 , 77,0 Thank you very much!!

Hello! I did an example using DSum, but I can´t see decimal values, for example, the correct value is 77,8 in second register...How to see this value? Thanks!

Please see my example db1.zip Can´t I did this kind of report, with these columns... a column do accumulate sales value ? Tks

Query Coluns/Values Client Column = a,b,c,d,e Sales Column =12,11,8,5,4 Accumulate Column=??????

I would like to accumulate SALES column and generate 'Accumulate column!'! CLIENT SALES ACCUMULATED COLUMN a 12 12 b 11 23 c 8 31 d 5 36 e 4...

Not worked! The result = #Error SQL Instruction: SELECT Table1.ID, Table1.Cliente, Table1.Vendas, ([Table1]![Cliente]+[Table1]![Vendas]) AS [accumlated column] FROM Table1; accumlated column: ([Table1]![Cliente]+[Table1]![Vendas])

Hi people! I would like to create accumulated column in access query,but I don´t know how do do it....Can you help me? Thanks! CLIENT SALES ACCUMULATED COLUMN a 12 12 b 11 12 + 11 = 23 c 8 23 + 8 = 31 d 5 31 +...