Repeated calculations

L

Lee Jones

I have a query that takes information from 2 tables plus 4 queries to give me a performance percentage. For some reason the caluclation for each unique ID number is repeated 101 times. Is there a way to prevent this from happening or do you know why it is happening

Thank
Lee
 
N

Nikos Yannacopoulos

Lee,

Just guessing here not knowing your query design, but chances are you are
combining tables/queries with a one-to-many relationship, so the left (one)
side is repeated as many times as the related records (ten bucks says 101)
on the many right (many) side. Use Totals (View > Totals) to group the
repeating rows.

HTH,
Nikos

Lee Jones said:
I have a query that takes information from 2 tables plus 4 queries to give
Click to expand...
me a performance percentage. For some reason the caluclation for each unique
ID number is repeated 101 times. Is there a way to prevent this from
happening or do you know why it is happening?
 
N

Nikos Yannacopoulos

Either through the menu, View > Totals, or pressing the Totals tool button
in the toolbar (The one with the Greek Sigma).
 
Top