In an Email last week, Christina asks:
“Do you know of an easy way to show Access query results in thousands?
Thanks DataPig.You are the like that black bird on Angry Birds – the bomb.”
Ok….so I added that last sentence. But Christina did ask a pretty good question.
.
Here’s how you can format Access query fields so that they show as thousands.
.
You first start with a working query. As you can see, this query shows revenue by market with an indication of how much of that revenue comes from Internet Sales. You’ll notice that the revenue columns inundate you with lots of numbers. That is to say, the revenue columns are difficult to read. Showing these columns in thousands would help readability.
» More: Formatting Access Queries to the Thousands Place
