Search results

p.s. this topic was of great help to me in solving this problem All the best, Adi

p.s. this topic was of great help to me to All the best, Adi

p.s. this topic was of great help to me, I hope it will help someone else with similar problem to. Cheers, Adi

thank you very much, problem solved.

Hello, I have recently made crosstab query/report which helps me in my every-day work but it is not fully complete. This is one example of my report: Basically, function of this report is to show much money is spent on car repairs monthly. This is how Sorting ang Grouping option is set (for...

Thank you all very much for prompt replys, I really appreciate it. @ bob fitz your code worked like charm, I just had to modify it a little bit because I use Microsoft Access 2003 ExtractDate: Mid([CurrentDate];4;2) Thank you!

Hello, I need help with following: in query I made I have one short date-type field called "CurrentDate". On my PC, default short date format is like this "MM/dd/yyyy". In my query I have one more field which looks like this "ExtractDate: Left([CurrentDate],2)". This is how it looks like...

How to segregate-single out part of the date field (mont)? Hello, I need help with following: in query I made I have one short date-type field called "CurrentDate". On my PC, default short date format is like this "MM/dd/yyyy". In my query I have one more field which looks like this...

p.s. if image is not displayed correctly or not visible, please let me know.

If image is not displayed correctly or not visible, please let me know.

.............

Hello, I recently made crosstab report which will help me a lot at my work-place and make it easyer for me to "monhly sales by country" which looks something similar to this: but report is not fully complete. Why? Because I must have these countries ordered in specific (not A to Z or Z to A)...

Thanks a lot Galaxiom for your help, I really appreciate it. Cheers;)

It looks like I made mistake on some fields and that's why ",00" was there:rolleyes: I have problem only with this now: img84.imageshack.us/img84/7041/unled2f.gif and I am not sure why doesn't it show "0,88" instead of ",88" or "0,10" instead of ",10"? I assume it has some problems with...

It looks like my problem isn't completely solve yet :):) On my report all fields are Sum values and there is a lot of data so looking through my four-page report I noticed some wierd values for some rows: img829.imageshack.us/img829/5130/12321.gif even with the fact that all columns have...

It looks like my problem isn't copmletely solve yet;)) On my report all fields are Sum values and there is a lot of data so looking through my four-page report I noticed some wierd values for some rows: img829.imageshack.us/img829/5130/12321.gif even with the fact that all columns have unique...

It looks like I din't completley solve my issue yet;)) It all works works good but looking through my report which contains many Sum fields, I have this issue: img829.imageshack.us/img829/5130/12321.gif so on some fields I have these wierd values like ",00" or ",10" ? I hope you can help...

Hello Galaxiom, I made mistake in my first post, this is the tight code which actually replaces decimal separator with comma (,) and thousand separator with dot (.) Replace(Replace(Replace(Format(123456.78,"#,###.00"),".","_"),",","."),"_",",") Following your suggestion now I have this code...

Hello GalaxiomAtHome, I tried to Use IIF(myfieldname=0,"-", Replace(etc...)) but at the end total amount looks like this: 123.45678 and it should be of this format "123.456,78"

Hello, On my report in Microsoft Access for all fields I have set-up this code in Control source: =Replace(Replace(Replace(Format(Sum([NameOfTheField]),"#,###.00"),".",""),",","."),"",",") and on this way I managed to replace format "123,456.78" to "123.456,78" because I need to have...