MS Access help needed

Hello everybody,

do we have any MS Access gurus here ??

I need a bit of help, and explanation why is my thing not working as I want

To cut things short, in the report, I would like to display a Total for some records (currency). But when I type in something like this:

Code:

=Sum([Payment1 subreport].[Report]![1st Payment])+Sum([Payment2 subreport].[Report]![2nd Payment])+Sum([Payment3 subreport].[Report]![3rd Payment])

it displays the Error msg instead of the total for this.
I tried pulling the data from the querries instead of subreport, from the reports they land into etc. with no luck.

If you could help me out, either PM me for more details or post here I will give more detailed explanation.

THANKS!

 

More details needed. What is the error? What is the schema of your database?

 

Put up the db file (w/ or w/o data) and we can all have a closer look. Make sure its virus free

 

Ok. My problem is in a Report called Sales All. Dont worry about some other stuff as it might not be yet finished

My biggest problem was to querry the 'main' table to extract records with payments in each month. I could do it so the records were repeated and extracted only payment from selected month. I had to do it in each separate querry. I wanted to combine these into one report so I could have the whole list of all Sales querries and then total not only for each of them but also the total of them three. See the database

All other comments and suggestions are welcome