If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
arithmetic operator won't work
try using two minus. example= [table1]--[table2]
remember two negatives = a positive. |
#2
|
|||
|
|||
arithmetic operator won't work
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. |
Thread Tools | |
Display Modes | |
|
|