Repeated calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
Either through the menu, View > Totals, or pressing the Totals tool button
in the toolbar (The one with the Greek Sigma).
 
Back
Top