Search results

  1. M

    Create a table of 1 column for integers 1 to 2000

    This should be simple but brain dead! In the end I used Excel and typed 1, 2, 3, 4 etc and stretched it to 2000 rows and pasted it into Acess. What is the SQL in Access to create a single column table of integers please? INSERT INTO..... ??? Thanks, Mel :confused:
  2. M

    Startup Module for Public Function/

    I can't seem to find or create a startup module. how do I create this please?
  3. M

    Change a field in a query with User Input?

    I know that using parameters I can input a particular value of a field but is it possible to modify the field itself in a query using a variable or VBA say using a text box value? I have a table with several fields each containing many rows: sales.AI sales.CG sales.HF etc. (18 similar...
  4. M

    Using Append Query in a loop to create 6 records in one go.

    :confused: Hello - I want to create a set of 6 records in an Access 2003(2000) database. I can create a record thus (SQL from append query): INSERT INTO tblTest ( AssessmentID, AssessmentNumber, Hazard, [q(y/n)], [c(y/n)], info, moreinfo ) SELECT [Input AssNo] & [Input Hazard] AS AssID, [Input...
Back
Top Bottom