| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 40385 | 2003-12-06 10:16:00 | Access 2000 | Ron Bakker (356) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 197920 | 2003-12-06 10:16:00 | Greetings I am working on a database that needs an equation made of several fields in a single record to then display the answer in the last field of each record. If I was doing this in Excel it would be no problem. Any Access masters out there? Cheers |
Ron Bakker (356) | ||
| 197921 | 2003-12-06 10:55:00 | sql is SELECT Sum([Table1]![number1]+[Table1]![number2]) AS total FROM Table1; this adds the numbers in feilds number1 and number2 then creates a new feild which gives the answer If you wish to use QBE (query by example) use the expression builder (looks like a wand over three horinzontal dots |
beama (111) | ||
| 1 | |||||