This should be easy but I have been working with excel for long I have completely forgotten how to do this in access.
What I need is an addition (SUM) formula. Just adding the cells together. My boss wants me to do this in access so I can run reports.
In excel it was something like =SUM(B5:B22). Where would I enter this in Access? (i.e in design view or datasheet view) Any assistance would be greatly appreciated.

once u have the data in table. its going to be raw data.

then when your makeing your query in design view, you going to have to make a field what does this calculation

i dont exactly rememerb the syntax though.

There are a couple of different ways you could do this. The first way would be to add a new textbox on the report where you want the sum, and put in a separate section from the one where the fields you want to sum are. Then, go into the properties of that textbox by right clicking on it, click the 'Data' tab, and choose 'Expression'. You can go through the various options and find the SUM operator, then include something like
=SUM( fieldNm)
It may actually be DSUM like the other poster said - not sure.

There are other ways too, but this would probably be the best. Good luck : )

Use DSum function....This function can add any values you want to reference from a table and return the resulting sum.

DSum(expr, domain, [criteria])

All three parameters are strings so use quotes....

example:
DSum("[TotalCost]", "tblItemPrices","[Type]='Car'")
this example returns the sum of the TotalCost field in the table tblItemPrices where the field Type is equal to Car