Export / Query Problem

  • Thread starter Thread starter edi
  • Start date Start date
E

edi

Hello!
I receive price data in the form 002600 (i.e.$26.00). I create a calculated
field in the query which multiplies it by .01 to get to 26.00. When I try to
export the query results as a text file or table I get an "invalid argument"
error message. Is it not possible to export calculations?
Cheers
 
edi said:
Hello!
I receive price data in the form 002600 (i.e.$26.00). I create a calculated
field in the query which multiplies it by .01 to get to 26.00. When I try to
export the query results as a text file or table I get an "invalid argument"
error message. Is it not possible to export calculations?
Cheers
Click to expand...


CREATE TABLE PriceData
(PriceDataID INTEGER
,Price CURRENCY
,CONSTRAINT pk_PriceData PRIMARY KEY (PriceDataID)
)

Sample Data

PriceDateID Price
1 002600


SELECT P1.Price * .01 AS CalculatedPrice
FROM PriceData AS P1


Results

CalculatedPrice
..26

The query executes normally.

The File Export operation:
File>Export>(*.txt; *.csv; *.tab; *.asc)>Save creates a text file with the
single 0.26 value in it.

I'm running Access 2000 SP-3 with Jet 4.0 SP-6.
 
Back
Top