Hi i am trying to do a report which calculates 3 different tables. However on the report i dont want any data except the final sum of the values i am trying to count.

I have added a screen shot and labeled the tables i am trying to calcualte. Does anyone have any advice on how i can do this. I need to show a report with the total value of each table which are linked to a project.

Many many thanks i hope i have made it easy to understand what i am trying to do

kabir hussein

Hi

I have done this in one of my databases.

What I ended up doing was to create a query based on each of the tables with the value I wanted, ( in my case it was a sum but in your case it will be count in the totals row for the field you want to count). you will then end up with a query with 1 value in 1 column.

Repeat this for each table you need a count for.

Then create a new query from the count queries you have just created, there will be no links between the queries.

This should then give you a single query containing each of the counts you need which you can then use to produce your report.

When I tried this in Access 97 it didn't work, but it does in 2000 and 2002

Hope this helps

Sue

many many thanks

I am just a bit confused as to how i can make a query calcualate the sum of two values and intotal output an overall sum. i.e. quantity * unit price = total and then calcuulate all the total.

thank you

kabir