G
Guest
Hi All
Im running a make table query which works great except for the formatting of
a calculated field which appears as number when I want it to be currency.
The bit of SQL i use is
[CARDSHIP]*([COST PRICE]/[UNITS IN PACK]) AS [SHIPPING COST] so I guess I
need to use some form of formatting to make it show the data as currency.
Ive tried doing this manually once the query has run but Access gives me
error messages about not having enough memory etc - there are about 500,000
records.
Thanks
Reggiee
Im running a make table query which works great except for the formatting of
a calculated field which appears as number when I want it to be currency.
The bit of SQL i use is
[CARDSHIP]*([COST PRICE]/[UNITS IN PACK]) AS [SHIPPING COST] so I guess I
need to use some form of formatting to make it show the data as currency.
Ive tried doing this manually once the query has run but Access gives me
error messages about not having enough memory etc - there are about 500,000
records.
Thanks
Reggiee