Compare 2 Fields

[carl]

My data looks like this:

Sym Price1 Price2
A 11.3 11.3
B 8.75 8.75
C 7.8 7.8
D 6.75 6.75
E 5.75 5.75

I would like to create a new field that will compare Price1 to Price2 and
return the difference between the 2 fields.

Is this something that can be done in Access ?

Thank you in advance

 

[Chris]

Absolutely. Make sure when you create your table, that Price1 and Price2 are
numeric. Then, when you create a query, build an expression something like
this:
Balrice1 - Price2 in the query grid field.