Search results

  1. 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...
  2. 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
  3. 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...
  4. 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...
  5. 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