duplicate records

Here is the information in excel spreadsheet format. I did not resend the table names.
 

Attachments

I'm sorry to do this to you, but your tables aren't properly structured. I'm building a query to generate the data you want and your Deduction fields shouldn't be in InsuranceTax, they should be their own table. That way you can just Sum them up. As it is now you would have to manually add every field together to get the Sum of your deductions.

With that said, is there one particular column of the expected results that is giving you trouble? What field is the one youo are having trouble with? Maybe I can help you with that.

But honestly, you should move all those deductions to a new table.
 
The field that I'm having trouble with is in connection with the finace charges. The query that I have built (you have the SQL of that query from an earlier response) is giving me the numbers twice for each year instead of only giving me the one number it should be. I had also sent you a copy of the outcome of this in an earlier response.

I have also tweaked my query to include the sum of each deduction using the null (nz) values so that it is giving me the totals of all of the deductions. We just felt that there was too much information already input into the tables to change them.

Once again, thank you very much for your help.
 

Users who are viewing this thread

Back
Top Bottom