Aug 6 2008, 05:29 PM
I have a query that uses the summation tool to add up a field for all records of a related table. It works exactly how I want it to except for 1 record. All of the records Sum correctly except for 1. that one record is double the amount of what the total should be. I have deleted and re-entered data, ran a compact & repair, changed data. Wierd because it only does that for the one record. I have changed data on other records, and it totals correctly but this one is double of what the Sum should be. !?? Any other ideas on what to do here?
It sounds to me that you actually have 2 or more Tables in the Query and one Record in one Table matches 2 Records in the other Table.
Try running the same Query as untotaled (ungrouped) simple Select Query filtered to the PK of the record you identified and see if this query returns 1 row or more.
Aug 7 2008, 12:05 PM
Van, Thanks for the help.
I looked through all Tables and queries and I just could not figure out what was happening. Thanks to your reply I have found my problem and fixed it!
You're welcome... Glad you fixed the problem...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here