Grand total in report

[Unicon]

Hi all,

Please see the attachments. I have a report where I allocated a certain amount for each vehicle. I just want to know how can I get that certain amount totals at the end of report as I Put formula as =Sum([Cost per month]) and it is not working and giving wrong values.

Please advise.

 

[vbaInet]

I don't see how you're getting the initial Cost per month field when you're not grouping by Month

 

[Unicon]

Thanks a lot.

Thats true I think I did a mistake in query. Will come back to you soon with problems

 

[vbaInet]

If you put something like:

MonthGroup: Month([DateField])

in the query, you should be able to group by that field.

 

[Unicon]

Thanks a lot.

Thats true I think I did a mistake in query. Will come back to you soon with problems

 

[Unicon]

Thanks vbaInet it's done. I did like this =DLookUp("[SumOfCost per month]","Main Table Query") and now its working.

Thanks once again

 

[vbaInet]

Happy to see you implemented a workaround.