Help with append query

[InvGrp]

I have a database that contain foreclosure records. I'd like to create a query that will ask for a date and all records that are LESS than the date will be moved to a different table.

I'd also created an icon on my form and I'd like to attach this query to it.

Any help will be appreciated.

Bruce

 

[InvGrp]

Move records

I've been able to create the query that finds the correct records NOW I need to know how to MOVE the records to the new Table.

Bruce

 

[KeithG]

Change the query from a Select Query to an Append Query.

 

[InvGrp]

I've done the append and it add the records to the new table BUT how do I get it to delete the records in the 1st table?

Thanks.

Bruce

 

[GaryPanic]

right you have done the hard work

your qry make a copy of it (file save as )
now change the type of qry to append -
try this out and see if it works - Yes good- no try again
the other version of the qry is going to be a delete qry
B4 you push the button ensure you have a good copy of the data

right now you have 2 qry
these need to be placed under the code of a button
so you are acutal doing 2 qry with 1 button-
job done ---
g

Not sure how Access focused you are - but wwhen you hit a problem - stop and slipt in into easy bits then combine them later (this is not always the solution but will help with your thought process)
g

 

[GaryPanic]

as you can see - nonone help you out to begin with - but you got the hard part solved ie the qry itself - now all we have outlien is change what the qry does - 1 append make another and change the type of qry to delete ..

 

[InvGrp]

I think I got the 2 queries done correctly.

So, how do I go about attaching these queries to the icon on my form?

Thanks.

Bruce

 

[GaryPanic]

ok I'll bail out on this bit - as its a bit completaced - i usually use buttons - if you want it to be on the onclick properties of an icon - then I let someone else answer this as I would be blagging it ....

cos I would not know how to (a) do this or (b) put an icon in a button.. probably could work it out - but the guys here have way more knowledge than me ...

 

[GaryPanic]

just do it

right on the properties of your icon go to onclick .... and this will open up a code put the comand to run qry in there- if you don't knwo what the code is

add a button (using the wizard and get it to run 1 of the qrys ) then copy the code and put it on the code above

 

[GaryPanic]

typeo -- should of been just done it ..

 

[gemma-the-husky]

out of interesty, why do you neeed to mover records to a different table?