Prev: Input and return multiple values from a query
Next: Multiple queries vs. one query
From: Song Su on 24 Jun 2008 10:42
In my crosstab query design, I put number in standard with 0 decimal in the
number field. When I export to excel and open it:
1. All the numbers are still 2 decimal
2. Most row hight are 15 except a few rows which is higher

How to fix the crosstab so the Excel would be perfect?

Thanks.


From: John Spencer on 24 Jun 2008 11:44
Please post the SQL of your query.
(Hint: Menu View: SQL)

Please tell use which field(s) have the problem. AS A GUESS, you need to use
CLng or Int around the number to force it to drop the decimal portion.

If you are using the format property on the query, you need to understand that
the format property affects the display of the data and when you export the
query the "display" does not come into play.

You could also use the Format function in the query to force the desired
number of decimal places.

Format([SomeField],"#,###")

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Song Su wrote:
> In my crosstab query design, I put number in standard with 0 decimal in the
> number field. When I export to excel and open it:
> 1. All the numbers are still 2 decimal
> 2. Most row hight are 15 except a few rows which is higher
>
> How to fix the crosstab so the Excel would be perfect?
>
> Thanks.
>
>
 | 
Pages: 1
Prev: Input and return multiple values from a query
Next: Multiple queries vs. one query