Take a look in the query to see if that row is the only one with values to the 4th decimal place. It might be that all the rows are showing 4 places but the others don't have values beyond 2.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My Nothing-to-do-with Access blog
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of kenaf42@yahoo.com
Sent: Tuesday, March 18, 2014 10:07 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Crosstab query Currency format problem
Access 07, as you can see although in property sheet of underlying query and this query I formatted currency as STANDARED I get the wrong format only on second row. Please help
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar