Adding variables

[cmcgath]

How do I set up a query to add groups of variables? Say, for instance, I
want to add the variables FO and FE and OC and CT and TB. Then I want to add
FN and VG, etc.

 

[Jeff Boyce]

I'm not quite following ...

Where are these "variables" coming from? Queries use data from tables (and
from other queries)...

Are you saying that you have multiple fields/columns and you wish to sum
them? If so, that's how you'd do it in a spreadsheet ... and Access is NOT
a spreadsheet! Using multiple columns to store different numbers means both
you and Access will have to work overtime to overcome the 'sheet data.

Please describe in a bit more detail what you have and what you are trying
to do. Folks here need that to be able to offer more specific suggestions.

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.