Search results

  1. B

    Incorrect Syntax For Subquery

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

    Incorrect Syntax For Subquery

    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...
  3. B

    How to limit number of records in a group

    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.
  4. B

    How to limit number of records in a group

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

    How to limit number of records in a group

    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...
  6. B

    How to limit number of records in a group

    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
  7. B

    Make smaller tables out of a bigger one

    Worked perfectly thanks alot!
  8. B

    Make smaller tables out of a bigger one

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

    How to combine the records of three tables into one table

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

    How to combine the records of three tables into one table

    Why report it the questions are different?
  11. B

    How to combine the records of three tables into one table

    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...
  12. B

    Make smaller tables out of a bigger one

    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...
  13. B

    How to make a new table using fields from another table with VBA

    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 :)
  14. B

    How to make a new table using fields from another table with VBA

    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
  15. B

    How to make a new table using fields from another table with VBA

    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?
  16. B

    How to make a new table using fields from another table with VBA

    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...
Back
Top Bottom