Sum ?

[HD Fatboy]

I am completly new to Access. So Please bear with me
I have a Data base with 5 Currency Fields in my Main table.

I can get totals From each one separtly, however, I can not get All 5 to total for a grand total.
Example Cost 1 $100..00
Example Cost 2 $100..00
Example Cost 3 $100..00
Example Cost 4 $100..00
Example Cost 5 $100..00

Total.........Nothing or an Error...
Been tring both query or report.....I ultimatley need it in a report by a date spread...
Been at this for two weeks now with searching and reading help, but just can not get this to work. Thanks in Advance.

[MMcCarthy]

In query create a new column

TotalCost: [ExampleCost1] + [ExampleCost2] + [ExampleCost3] + [ExampleCost4] + [ExampleCost5]
You can then sum this field to get the total overall cost.

I am completly new to Access. So Please bear with me
I have a Data base with 5 Currency Fields in my Main table.

I can get totals From each one separtly, however, I can not get All 5 to total for a grand total.
Example Cost 1 $100..00
Example Cost 2 $100..00
Example Cost 3 $100..00
Example Cost 4 $100..00
Example Cost 5 $100..00

Total.........Nothing or an Error...
Been tring both query or report.....I ultimatley need it in a report by a date spread...
Been at this for two weeks now with searching and reading help, but just can not get this to work. Thanks in Advance.

[comteck]

Create your query, and make it a totals query by clicking on the appropriate icon on the toolbar (It'll say "Totals" when you move the mouse over the top of it). A new field appears called Total. Keep "Group By" in all these fields, except the one that you want to do the Sum. On that one, click the pull down menu and choose "Sum". This is the field that will have all your fields added together:
TotalCost: ([Cost1]+[Cost2]+[Cost3]+[Cost4]+[Cost5])

Also, since you want to select a certain date range, I'm assuming you have a date field in your table. Make sure it's selected in the query, and in the criteria field (Under the Date field), type the following:

Between [Enter Start Date] and [Enter End Date]

This will prompt you for your Start and End Dates.

Hope this helps.
comteck

[HD Fatboy]

Thanks for the replys I am still doing something wrong here.
here is what the query looks like in Design View no error but no total either.

Field: TotalCost: (formula) Cost1 Cost2 Cost3 Cost4 Cost5

Table: Tool Damage Tool Damage Tool Damage Tool Damage Tool Damage

Total:Expressions(changes itself) the remainder is group by

All check boxes are checked.....

This is killing me I know I am getting closer......

[HD Fatboy]

No More Ideas?...LOL....

[MMcCarthy]

Go to the Queries SQL view and copy and paste the code here. I can't follow what you've written.

No More Ideas?...LOL....

[HD Fatboy]

Thanks I well try that....I followed the previous directions and posted the fields I had in query in design view......Sorry to confuse you