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

 

[style45 via AccessMonster.com]

Jeff,
This how I have this formatted in a query:
Total Quantity: FormatNumber([Order Details for Large Group Rebate].[Quantity]
)

...when I put Total Quantity: CInt([Order Details for Large Group Rebate].
[Quantity]) it comes up saying "Invalid Use of Null"

Regards,
Kathi

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

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

[quoted text clipped - 4 lines]

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

 

[Jeff Boyce]

Kathi

?Perhaps at least one of your records has a "value" of Null in that field?

You could compensate for that using something like:

Total Quantity: CInt(Nz([Order Details for Large Group
Rebate].[Quantity]),0)

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,
This how I have this formatted in a query:
Total Quantity: FormatNumber([Order Details for Large Group
Rebate].[Quantity]
)

..when I put Total Quantity: CInt([Order Details for Large Group Rebate].
[Quantity]) it comes up saying "Invalid Use of Null"

Regards,
Kathi

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

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

[quoted text clipped - 4 lines]

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