format new field in create query

[BrotherOmar]

I want to create a new table based on a current table in the same db and will use a create table query. Easy so far. I want to add a field in the new table that didn not exist in the old table and I want to do this in the in the create table query. I can add the new field but its format is text.

How can I run this create table query so that the new field is formatted as currency


thanks,

omar

 

[PHV]

Any chance you could post your actual SQL code ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BrotherOmar]

SELECT [tblBL-Orig].[UnitPrice], [tblBL-Orig].[Extended Price], [tblBL-Orig].[Sales Territory from Sales Transaction], <b>FormatCurrency(0) AS FinalExtPrice</b> INTO tblBL
FROM [tblBL-Orig];

here is a snipit.

the bold bit is the new column. i tried using FormatCurrency() function as a way to set the field format but that doesn't work--it only dipslays the contents as currency, the field is still set as text. there has to be an easy way to do this.

 

[PHV]

SELECT UnitPrice, [Extended Price], [Sales Territory from Sales Transaction], CCur(0) AS FinalExtPrice INTO tblBL
FROM [tblBL-Orig];


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BrotherOmar]

nice. thanks.