Append & Delete

[Toucantango]

I have been trawling through this forum for hours now and still have no satifactory insight into what I am to do. I read about append and criteria but no one seems to expand - I have a feeling it's all in the Sql but have no clue where to begin.

Background

I have made a qry that pulls info from two tables (tblMembers & tblAccountDetails)- I have made it an apend qry.

The qry will be run from a cmdButton on a form that contains a record (frmPrimaryMembers)...(Contains Members Details etc).

What I would like to do

1. Apply the query to just the current record in view
2. Insert the resulting data into a new table (tblExMembers) - This is not related as it is merely a record of ex-members.
3. Delete parts of the record in view (everything but the ID)

I have tried different things but keep getting stuck.
Any help would be greatly appreciated.
Touc.

 

[M8KWR]

basically you need 3 queries to do everything you want, which can all be run from one command button

1. Unsure what exaclty you are trying to do here
2. Append query
3. Update query

to use the current record that the user is on you would use something like this within the queries

[forms]![form_name]![IDnumber]

If you could supply the db in A97 format then i could write the whole thing for you, if that helps.

If not, if you could go into a bit more detail with each stage that would be a great help.

 

[SunWuKung]

Are you sure this is what you want to do?
It is quite rare to store data twice in a database.

If it is just about displaying data in a certain way you can do it with a select query and a form.

If you want to actually modify your data (eg. set certain values to Null) it is usually an Update Query.
Delete Queries always delete the entire record.

hth.
SWK