Quarter Totals


S

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?
 
Ad

Advertisements

J

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
 
S

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

Jeff said:
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?
 
Ad

Advertisements

J

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

style45 via AccessMonster.com said:
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

Jeff said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

quarterly changes 1
Quarterly Reports 3
Quarterly Reports 1
Quarter of Year 3
grouping quarters 3
Increment by quarter? 2
Quarterly Restriction 11
Fiscal Quarter 1

Top