Quarter Totals

[style45]

I currently have a crosstab query that I used to count the number of each
type of quantity of volume per quarter but its giving me dollar amount vs a
for whole count. For example:
Q1 Q2 Q3 Q4
text $50.00 $25.00

How will I be able to have this read as a whole number?

 

[Jeff Boyce]

Are you saying that "50" and "25" are the correct numbers, but that the
query is displaying these numbers as if they were currency?

If so, in the query's design mode, you could try formatting that field as an
integer. If that doesn't work, you could try "coercing" the field into
integer with the CInt() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP