Format a number as currency 1

[JR2913]

I have a make table query where I have a calculated field called Charge. I want to format this data item as currency so that when the table is created the field format is defined as currency.

The current syntax in design view for the variable is:

Charge: [Hours]*[tblAdultAttend.Cost]<Format(&quot;£00.00&quot

I can't get the format right to generate the data as I want it, and have tried a number of different strategies to create the right format.

Can anyone help put this right, please?

Many thanks.

John R

 

[jrbarnett]

Format ([Hours]*[tblAdultAttend.Cost], &quot;Currency&quot

This will use the currency format in the control panel.

John

 

[JR2913]

Fantastic, John.

Thanks very much - works a treat.

Interestingly, though, when the table is created the field Charge is defined as a Text field rather than Currency. I'm not sure what effect this might have later on when I want to do some calculations with the data. Any suggestions?

John R