Move data to different table using query

[kiask2343]

Ok here is what I've got.
I have a table called (EQUIP REG)
It contains all the information to the equipment in the hospitol.
next i have a table called (WO REG)
It contains all the information for the workorders for the equipment.

In the EQUIP REG table I have field titled (PM) this is the date that the equipment is due for PM's. Now I could just run a query for all the equipment on a given date called "MONTHLYPM" and then "open" the workorders by hand....but would be an all day job becuase there are nearly a thousand PM's a month. What i need is a wuery to run off of the above mention query that will copy the some data from the EQUIP REG table to the WO REG table. I only need the fields called "MMCN" "SERIAL" "MODEL" and "LOCATION"

I know very little about access and even less about VBA, so who ever is brave enough to help me must be able to talk on a very low level.
thanks for any help in advance.

 

[tkoh78]

1. Simple solution would be using update query. Do internet search for how to use update query.
2. More advance solution would be create a select query with both tables joined in a relationship. Set-up a creteria for dates.

I'm sorry I can't go into details because I can't see your database. If you can attach a stripped down database to work with. I may be able to help you out more.

 

[kiask2343]

1. Simple solution would be using update query. Do internet search for how to use update query.
2. More advance solution would be create a select query with both tables joined in a relationship. Set-up a creteria for dates.

I'm sorry I can't go into details because I can't see your database. If you can attach a stripped down database to work with. I may be able to help you out more.

Well I have read all about append queries but I can't seem to get it to do what I am wanting it to. I really need the select data to be copied in the WO REG table perminitly becuaes after the workorder has been completed it is archived in the table.