Currency in Combo Boxes

[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

 

[Wayne-I-M]

SELECT CCur([TableName]![Price]*[TableName]![Markup]) AS SaleCost
FROM TableName;

 

[Dominic Vella]

That's so appreciated.

The results are not right justified, but I'm happy enough with that
fantastic result.

Thank you.


Dominic

SELECT CCur([TableName]![Price]*[TableName]![Markup]) AS SaleCost
FROM TableName;



--
Wayne
Manchester, England.

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

 

[Studebaker]

Hello,

I have the same problem where the $ sign is not showing in my combo box (it
does appear when I select a value, though).
My RowSource currently says:
SELECT Pricing.Price, Pricing.Description FROM Pricing ORDER BY
Pricing.Price;

I tried to add the CCur(etc.) but I got an error message.

Can you help me so I can get a $ sign to appear next to the prices in my
combo box?

Thanks

SELECT CCur([TableName]![Price]*[TableName]![Markup]) AS SaleCost
FROM TableName;



--
Wayne
Manchester, England.

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