Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Query Procedural Problem in Access 2003

    I download thousands of records once a month to run through calculation procedures.

    I need to work on a subset of these records so, if I’m correct, a select query won’t work because that produces a dynaset, not an actual table.

    The subset table records must adhere to field properties that I define in the datasheet.

    So I think I need to have an existing table that holds my defined field properties.

    Then I guess I need to have a delete query to empty this table each month, and then an append query to add the new subset records to the table of delete records so I don’t have to reset the field properties in the datasheet each month.

    So . . .

    1.> download and import the data into Access
    2.> Perform a delete query to remove the previous month’s records.
    3.> Perform an append query to add the new records.

    Is this the best way to accomplish this?

    Can I then convert the queries to SQL and attach to a button and run the entire thing all at once with a push of that button?

    Thanks much . . .

  2. #2
    Join Date
    Jul 2004
    Southampton, UK
    I use the approach you've outlined for much the same thing. Works fine for me.

    You can get a button to run SQL queries sequentially using either macros or vba.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts