D
Dominic Vella
I'm using MS-Access 2000
I have form displaying a list of products to choose from within a combo box.
On my Windows-WP machine I has an SQL statement with a
Format([price]*[markup],"currency") which worked fine.
Since moving to Windows-Vista, the format no longer works in the SQL
statement. I've had to revert to using [price]*[markup]. As you can
imagine, the pricing in my list is now left justified, without the $'s and
the decimal place changes per line.
Is there a way to get the Format function working again in my combo boxes
again?, or
Is there a way to create an SQL statment to display currency for particular
calculated fields?
Thanks in advance
Dominic
I have form displaying a list of products to choose from within a combo box.
On my Windows-WP machine I has an SQL statement with a
Format([price]*[markup],"currency") which worked fine.
Since moving to Windows-Vista, the format no longer works in the SQL
statement. I've had to revert to using [price]*[markup]. As you can
imagine, the pricing in my list is now left justified, without the $'s and
the decimal place changes per line.
Is there a way to get the Format function working again in my combo boxes
again?, or
Is there a way to create an SQL statment to display currency for particular
calculated fields?
Thanks in advance
Dominic