Formulas

[Amy]

I am needing help on how to create a formula to add
various fields. For example, I need to add. Management
Travel Hours and Management Planning Hours. For each
individual activity. How would I set this up in my query.

 

[Ian]

Not 100% sure of what you mean, but if you simply want to add the fields
together then you would in the query grid. Right click on a blank field and
press Shift and F2, this will give you more space to see what you are
typing. Then enter:

Total: Sum([tablename]![Management Travel Hours]+[tablename]![Management
Planning Hours])

This would only work though if the hours are in whole numbers, if your hours
are in minutes then you need to use one of the built in functions (similar
to DateAdd, but I can't right now remember the name) Try a quick search on
the help for TimeAdd or something similar and it should help you out.

Sorry could not help much more, but hope thats of some help.

Ian

 

[John Vinson]

I am needing help on how to create a formula to add
various fields. For example, I need to add. Management
Travel Hours and Management Planning Hours. For each
individual activity. How would I set this up in my query.

Type

[Management Travel Hours] + [Management Planning Hours]

in a vacant Field cell... but I'm not sure that's what you're asking!