Search results

  1. K

    Using the information inputted in a table as a table name

    Hi, I was wondering if anyone could tell me the correct syntax, or even if its possible to do the following, please remember that this code wil be written within the VB code... not in a query... sqlstring = " " sqlstring = sqlstring & " INSERT INTO markup SELECT TOP 1 Customername AS...
  2. K

    iif statements... then the WHERE clause? help!

    Hi, here is my query which runs within the VB code... queryString2 = "" queryString2 = queryString2 & " INSERT INTO markup SELECT TOP 1 JDE_Customer_No AS [JDE Customer No]," queryString2 = queryString2 & " Custom2.Customer_Name AS [Customer Name]," queryString2 = queryString2 &...
  3. K

    SQL problem within Access

    Hi everyone, Iv been working on this access program which i have inherited from my predecessor. here is the query (inlcuding the do until loop etc) which i have found i need to modify to do wat i want; Do Until select_part_rst.EOF num = num + 1...
Back
Top Bottom