Update Query?

[aldunford]

I have a select query that asks the user several parameters such as employee
name, deduction id, last pay date, current pay date, intrest. And it returns
the correct results. This query would run every pay period. So that it
gives the intrest rate based on how many days between the pay dates.

I want to take this information and have it placed in a table. I need it to
keep all of the information from the query.

I have tried to do an Update Query but I get an error that says operation
must use an updateble query????

Please help!! Thanks

 

[Bob Cutler]

You need an "Append" or "Create Table" query to put the information into a
table. The type you choose depends on whether you have already created a
table definition or whether you want Access to create the definition when the
query runs. If you use an "Append" query, but want the data cleared before
you run the query, you'll need to create a DELETE * FROM TABLENAME query,
then run the queries in sequence from a macro or from code.

 

[aldunford]

Bob,

Thanks. After I posted my question I realized I needed an Append Query!
Thanks for the help!!!