Currency in Combo Boxes

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
 
W

Wayne-I-M

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

Dominic Vella

That's so appreciated.

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

Thank you.


Dominic

Wayne-I-M said:
SELECT CCur([TableName]![Price]*[TableName]![Markup]) AS SaleCost
FROM TableName;



--
Wayne
Manchester, England.



Dominic Vella said:
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
 
S

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

Wayne-I-M said:
SELECT CCur([TableName]![Price]*[TableName]![Markup]) AS SaleCost
FROM TableName;



--
Wayne
Manchester, England.



Dominic Vella said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top