Discussion Locked
0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a database that calculates client contributions. One client can have contributions from 2 to 5 different accounts. I put all of those amounts, based on pay date, in one table with an append query. Then I run another query that sums the amounts and puts the results in another table. In between that step, some of the contributions come up missing. Does anyone have any ideas as to why values are missing?
5 replies
by john_wills
Look for nulls in other columns of your table.
by rboyer
Poster rated this answer.
can you confirm 100% that you have all the data after the append operation ? So we can focus on the last (sum) part. Null fields shouldn't be an issue. Do you include other fields/groupings in the last query ? Do you have any links to other tables, or just other tables in the query ?
As long as you have a straight-forward "group by client" and "sum by contribution" (and nothing else), I can't see a problem.
by rboyer
Poster rated this answer.
by rboyer
This question was closed by the author
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
Question Unanswered
Best Low-Latency VPN Protocols for Competitive Mobile and Online Gaming
0 helpful
0 replies
0 helpful
5 replies
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies