record with doubled value

[fgerard via AccessMonster.com]

HELP !!!
I have a report based on a query that returns summed up values of multiple
records which worked fine so far.
Then one day I realise there is one record (ony one so far) that shows a
doubled value. ????? This doesn't make any sens at all. The values in
question are totaled worked hours I keep track of thru a form based on a
table. I have another report that shows the detailed worked hours wich
correspond to what has been fed into the system. There is no mistake on this
one.
Is there anyone who could give me clue on what 's going on ???
Thanks in advance
Frankie.

 

[Allen Browne]

The query has more than one table. The record that shows double value has 2
related records in another table, i.e. it appears on 2 rows of the query.
Consequently, when you add it up, you get double the value.

 

[fgerard via AccessMonster.com]

Thank you for your answer.
Actually, the query has two tables. One contains the daily worked hours, the
other contains contract infos.
I did a sum on the worked hours column of the query. All results are fine
except for one that is doubled.
Any other ideas ??

The query has more than one table. The record that shows double value has 2
related records in another table, i.e. it appears on 2 rows of the query.
Consequently, when you add it up, you get double the value.

HELP !!!
I have a report based on a query that returns summed up values of

[quoted text clipped - 10 lines]

Thanks in advance
Frankie.

 

[Duane Hookom]

I would go back and check against Allen's response. I assume your two tables
in the query have a join line between them. Is one of the fields in the join
a primary key?

--
Duane Hookom
MS Access MVP
--

Thank you for your answer.
Actually, the query has two tables. One contains the daily worked hours,
the
other contains contract infos.
I did a sum on the worked hours column of the query. All results are fine
except for one that is doubled.
Any other ideas ??

The query has more than one table. The record that shows double value has
2
related records in another table, i.e. it appears on 2 rows of the query.
Consequently, when you add it up, you get double the value.

HELP !!!
I have a report based on a query that returns summed up values of

[quoted text clipped - 10 lines]

Thanks in advance
Frankie.

 

[fgerard via AccessMonster.com]

The answer is yes.

I would go back and check against Allen's response. I assume your two tables
in the query have a join line between them. Is one of the fields in the join
a primary key?

Thank you for your answer.
Actually, the query has two tables. One contains the daily worked hours,

[quoted text clipped - 14 lines]

 

[Duane Hookom]

Well, we can't see your actual query or base table records so you will need
to trouble-shoot. Access queries don't double values without either two
records on one side of the join where you expect only one or duplicate
records on the other side of the join.

--
Duane Hookom
MS Access MVP
--

The answer is yes.

I would go back and check against Allen's response. I assume your two
tables
in the query have a join line between them. Is one of the fields in the
join
a primary key?

Thank you for your answer.
Actually, the query has two tables. One contains the daily worked hours,

[quoted text clipped - 14 lines]

Thanks in advance
Frankie.

 

[fgerard via AccessMonster.com]

Allen was right. I have found the duplicate record.
Thanks again for your help
Frankie

Well, we can't see your actual query or base table records so you will need
to trouble-shoot. Access queries don't double values without either two
records on one side of the join where you expect only one or duplicate
records on the other side of the join.

The answer is yes.

[quoted text clipped - 9 lines]