Currency format

[Guest]

Having created a new field converted from various currencies into dollars,
how do I make this one field for dollars only without having to go into
regional settings to change this.
I have other fields which are required to be in Euro and Pound format hence
I cannot change these settings.
Any ideas?
many thanks,
Matt

 

[Jamie Collins]

Having created a new field converted from various currencies into dollars,
how do I make this one field for dollars only

I suggest you have two columns, one for 'measure' and the other for
'value', and use a validation rule (or CHECK constraint) to ensure the
'measurre' is always dollars e.g.

CREATE TABLE Test4 (
total_budget_currency_code CHAR(3) DEFAULT 'USD' NOT NULL,
CHECK (total_budget_currency_code = 'USD'),
total_budget_amount DECIMAL(19, 4) NOT NULL
);

Formatting is for the front end e.g. use Format$(n, "$#,##0.00") in VBA
code.

Jamie.

--