G
gator
I need to SUM multiple field values in a row. I know how to set it up in the
Query design using a calculated field and I realize Excel does this. The
reason I want to do it in Access because it seems to have more automation,
whereas if I build the query, I can run it for the result, opposed to Excel
where more steps might need to be done for the same result. Are there any
query wizards in 2003 that automatically calculate multiple field values, or
am I stuck by doing it long-hand by setting up the query design calculated
field by adding each column/field heading to the field name.....or by setting
up SQL?
Query design using a calculated field and I realize Excel does this. The
reason I want to do it in Access because it seems to have more automation,
whereas if I build the query, I can run it for the result, opposed to Excel
where more steps might need to be done for the same result. Are there any
query wizards in 2003 that automatically calculate multiple field values, or
am I stuck by doing it long-hand by setting up the query design calculated
field by adding each column/field heading to the field name.....or by setting
up SQL?