Search results

  1. L

    "SELECT TOP n" and "UNION"

    I am hoping someone can help me with the following statement: SELECT TOP 3 * FROM RIDSCORE WHERE ((RIDSCORE.RIDER_L) = "LEWANDOWSKI") And ((RIDSCORE.RIDER_F) = "Amanda") And ((RIDSCORE.LEVEL) = "B1" ) ORDER BY RIDSCORE.LEVEL UNION SELECT TOP 3 * FROM RIDSCORE WHERE ((RIDSCORE.RIDER_L) =...
  2. L

    'SELECT TOP n' and 'UNION' sql statement

    I am hoping someone can help me with the following statement: SELECT TOP 3 * FROM RIDSCORE WHERE ((RIDSCORE.RIDER_L) = "LEWANDOWSKI") And ((RIDSCORE.RIDER_F) = "Amanda") And ((RIDSCORE.LEVEL) = "B1" ) ORDER BY RIDSCORE.LEVEL UNION SELECT TOP 3 * FROM RIDSCORE WHERE ((RIDSCORE.RIDER_L) =...
  3. L

    public vs dim

    When/what are the most appropriate uses for either Dim or Public? Why one over the other?
  4. L

    sub and temp query

    Hope someone here can help me... I keep getting run-time error '3061 - Too few parameters, expected one' on the 'Set class_rst = ' line of the following sub. I went and had a look the article mentioned previously about '3061' but it wasn't any help as it seemed to deal with permanent queries...
  5. L

    temporary queries

    Hope someone here can help me... I keep getting run-time error '3061 - Too few parameters, expected one' on the 'Set class_rst = ' line of the following sub: Sub Get_horse_recs(class_rst, class) sql_string = "" RIDER_F = query_rst(0) RIDER_L = query_rst(1) l1 = "SELECT * " l2 =...
Back
Top Bottom