I have three column in table named Col1 : Col2 : Col3. I want sum of Col1 and Col2 in Col3. Is it possible in Access 2007?
I have three column in table named Col1 : Col2 : Col3. I want sum of Col1 and Col2 in Col3. Is it possible in Access 2007?
You can do that in a calculated field (expression) in a query, i.e.
MySum: [Col1] + [Col2] + [Col3]
If you want to read up on it more, Access's built-in help files has information on creating calculated fields (expressions) in queries. Any beginner Access book will have it to.