Query Procedural Problem in Access 2003

[Rickinrsm]

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 . . .


Rick ~ Access Newbie

 

[lupins46]

Yes to both of your questions.

But there is no great benefit in converting the saved queries to sql. Add one button to run the first query and then copy the code and change the query name.

You might need to consider using the Docmd.Setwarnings statement once you have got it working.