CrossTab /Calculate

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

Maxwell

Hello,

I am creating a crosstab query. The query works fine,
however my value is coming up with too many ending zeros.
For example, what i want is to see the number 90 but when
I run the query, it comes out 9000.
So i want to do a calcualtion within this query to divide
by 100 to give me what i want.

So what do i need to do to tweek my "Value"?

Result of my query is UPC items going down, Time(3
yrs/week) going across and the value to fill the rest.

Please advise.
 
Switch the query to SQL View (View menu, from query design).

Where you see:
Sum([MyField]) As SumOfMyField
change it to:
Sum([MyField])/100 As SumOfMyField
 
You are the true Guru!!!
-----Original Message-----
Switch the query to SQL View (View menu, from query design).

Where you see:
Sum([MyField]) As SumOfMyField
change it to:
Sum([MyField])/100 As SumOfMyField

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hello,

I am creating a crosstab query. The query works fine,
however my value is coming up with too many ending zeros.
For example, what i want is to see the number 90 but when
I run the query, it comes out 9000.
So i want to do a calcualtion within this query to divide
by 100 to give me what i want.

So what do i need to do to tweek my "Value"?

Result of my query is UPC items going down, Time(3
yrs/week) going across and the value to fill the rest.

Please advise.
Click to expand...


.
Click to expand...
 
Back
Top