Using two minus symbols will work just fine in a Query as a calculated field
or in the Control Source property of a control on a form; however,
(presuming that you did not really name your fields table1 and table2), you
need to provide field names not table names:

In a query:
TotalAmount: [table1].[SomeField]--[table2].[SomeOtherField]




--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


"Benny" wrote in message
news
try using two minus. example= [table1]--[table2]

remember two negatives = a positive.