CREATE TOP 5 LIST PER DATE

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

Guest

hi

i am a beginner and I am trying to get a top 3 downtime per date for a
machine.
I copied this from another help section

In (Select Top 3 [DOWNTIME] From [5 - TREND BY CAUSE Line 2] Where
[DATE]=[SHIFT DATA ENTRY].[DATE] Order By [DOWNTIME] Desc)

but instead of giveing me report like below
300 12/7
200 12/7
50 12/7
500 11/7
450 11/7
10 11/7

It only gives me top 3 downtime regardless of date like
500 11/7
450 11/7
300 12/7

please help, thanks.
 
What are the table names you are working with? What are the field names and
datatype of the fields?
It looks like you wanted data from a single date ( Where [DATE]=[SHIFT DATA
ENTRY].[DATE] ) but your results show two dates.
 
Back
Top