Recent content by Babak

I got it to work, thanks for the help guys.

SELECT Line, Downtime FROM [Top 3 DownTime] WHERE Downtime IN ( SELECT TOP 3 Downtime FROM [Top 3 DownTime] as S WHERE S.Line = [Top 3 DownTime].Line ORDER BY Downtime DESC ); This is my subquery. For some reason, I am getting an inccorect syntax error. "Top 3 Downtime" is my...

Hey David I did method one but for some reason, I am getting the top 3 period instead of the top 3 for each line. Can you look at my code above and see what I did wrong.

To be more specific, its only returning the top 3 "Downtime" without taking "line" into consideration

I want the top 3 "Downtime" for each "Line". The table is called "Top 3 Downtime" and I put this in the criteria of Downtime. In (Select Top 3 [Downtime] From [Top 3 DownTime] Where [Line]=[Top 3 DownTime].[Line] Order By [Downtime] Desc) For some reason, this is only returning the top...

Hey I have a report that is group based on a number refered to as "Line". I want to only have three records per group. How can I do this? Thanks in advance

Worked perfectly thanks alot!

Thats a good idea ted let me try to see if it work!

First question was related to splitting up a table, second was combining.

Why report it the questions are different?

I have three tables. I want to combine all the records in these tables into one table. I need VBA code to do this. The first table is called down1, the second table is called down2 and the third table is called down3. All these tables contain the same fields so I don't think combining them will...

I have a table with 3 fields. The fields are down1, down2 and down3. . I would like to use this table to create a new table (downtime). What I need too do is loop through each record in the table and place the three fields independently in my new table. For example, I would like to go to the...

Thanks guys but I found another way to do what I need without the need of creating a new table. Thanks for your time. PS. Sorry for posting the same question twice :)

This is for my access database. When I first created it, I made my table include 3 downtime issues (down1,down2,down3). I want to now split this into a another table. It may sound unessacry but thats what he wants done so I have no choice. Thanks

I do need to do this because my boss wants to be able to apply a filter. He wants to see the downtimes in order from highest to lowest. Since each record contains three downtimes, I need to split the table up. Do you know code that will do this?