Help! I can't get Access to add!

I’m trying to set up a database to track client payments for tax purposes (instead of using a written out ledger). I have a table and form set up to enter in each type of income (haircuts, color, tips), etc., but I can’t get the damn thing to add horizontally.

For example, I have a query set up that will give me the weeks’ totals for how much I made on haircuts, how much I made on colors, etc. But I can’t get it to add those numbers up to give me a total that I made for the week.

How do I do this? It shouldn’t be that hard…

“WeeklyTotal: Sum(Haircuts) + Sum(Color) + Sum(Tips)…”

or

Have in a query "Total: Haircuts + Color + Tips… " and have another query based on that one with “WeeklyTotal: Sum(Total)”
If any of the columns are null values (no number, not even zero), the addition won’t work. You’ll have to put “Nz(Haircuts, 0)” instead of just “Haircuts” in whichever method you choose.

I’m sorry for acting like a complete idiot, but i can’t figure out how to do what you are saying - is there some dialog box that I enter in the stuff in quotes above? In design view, all I can do is sum up one column at a time (all i can do is sum of “Sum Tips”, which does nothing.

jbird has it right. Look closely at the very first line in his post. Type that in (without the quotes) the top row of a blank column.

The syntax goes like this: Fieldname: formula

This what’s known in Access as a calculated field. One caveat is I believe you’ll have to enclose the field names used in your formula in square brackets, like thus: Weekly Total: Sum([Haircuts]) + Sum([Color]) etc. “Weekly Total” is the name assigned to your calculated field.

You can build it if you save the query first with all of the fields that you want to sum already displayed in a column. Then reopen the query, click in the top row of the next blank column and then click on the ellipses (build) button on the right side of the blank box. The build expression dialog will appear and all of the columns you have defined in the query when it was saved will show up in the middle column at the bottom. Simply double-click the first field you want to add, then the “+” button (or type “+”), then double-click the next field, and so on. Once you have your expression built, click OK and it will appear in the once blank column that you started in. You may then delete the other columns if you do not need to see them in your query.

I’m sorry for acting like a complete idiot, but i can’t figure out how to do what you are saying - is there some dialog box that I enter in the stuff in quotes above? In design view, all I can do is sum up one column at a time (all i can do is sum of “Sum Tips”, which does nothing.

whoops delayed double post. sorry.