Mystery duplicates in sum query

DJDocEBrown

New member
Local time
Yesterday, 21:51
Joined
Sep 18, 2013
Messages
4
I have read every sum query question asked here and can't find one like this. Maybe I missed it.

I keep getting mystery entries in the sum query I am using on a table. For example. I have a table with multiple columns. This query is only interested in two of them [ticketnum] and [cost]. The table for which they are in is [ItemList] where each [ticketnum] can have multiple [cost] entries. The query is supposed to sum the multiple [cost] entries and return the sum of them adjacent only one [ticketnum]. S

Sound simple right? So I tried turning unique entries both on and off with no success. I will share with you some of the results:

[ItemList]
[ticketnum] [cost]
111333 4.00
111333 6.00


Results:
111333 20.00

if I remove the sum from the query design I get the following results:

111333 2.50
111333 4.00
111333 6.00
111333 1.50

Note in that 2.50 and 1.50 are not even in table [ItemList]. Where do these results originate from? This is just one of many examples in this query. Returned entries with only one entry in the table double as well even with unique turned on. I am truly baffled by this because this is one of the most rudimentary queries to use.

Has anyone come across this before?
 
Please post the SQL view of your query.
 
even upload a sample DB, because this sounds wierd....
 

Users who are viewing this thread

Back
Top Bottom