Avatar of Bob Collison
Bob Collison
Flag for Canada

asked on 

Access 2016 Report Convert Text To Currency

Hi Experts,

I have a text field [SELECTION_25] in a table that is the source of a report detail line that contains a currency value.  e.g. $100.00.

I need to calculate the total amount to display it in the Report Footer.  The field in the Report Footer has a Control Source entry of:

When I run the report I get the followin Error:
Data type mismatch in criteria expression.

Therefore I need to convert the Text data in the field to Currency so that it can be 'Totaled'.

I can't figuer out how to do this.

Bob C.
Microsoft Access

Avatar of undefined
Last Comment
Bob Collison

8/22/2022 - Mon