Calculation for Invoicing Solution Report??

[siou]

I have created a REPORTS database that links to an INVOICE database.

In the INVOICE database, there are many invoices that use a portal to call upon information from the STYLES database and information that is ordered by making choices in the portal in the invoices is stored in the REPORTS database.

This is the problem.

I can make summary Reports in the REPORTS SYSTEM of the TOTAL of the LINE ITEMS, which is a calculation that is made in the portal and is stored in REPORTS, but when I need to make a Summary Report that Sumarizes the Totals of each invoice, and tax and shipping, etc..Information that is stored in the INVOICE database, the SUMMARY reports in the REPORTS database does not for the life of me return the right information.

I have tried to make summary fields in the INVOICES database of, for example the TOTAL OF ALL TAX for that specific invoice, and then make using the relationship between the databases, make a field in the REPORTS database to bring up the information, but it just shows the TOTAL OF ALL TAX for all of the invoices in the database.

I then tried to make fields in the REPORTS database which made it so that the calculations that would need to be made for each Invoice, as far as tax and shipping, etc, in the REPORTS database, but that did not even bring up any information.

I am so stuck, and I really need to finish this.

So, I guess my question summarized is:

How do I make a report for a group of records that store calculations for the same record in multiple databases?

I need to make an Report that summarizes daily, weekly and monthly by invoice and gives totals for each invoice and then totals of all daily, weekly or monthly of all invoices chosen.

I hope that does not sound so messed up, I have been going in circles for days, and I am so confused. I just need to finish this part of my database.

Thanks to all of you!

Ami