Move data from one table to another with 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.

[PEB]

Hi,

So to do this:

1. Create in the query designer a query based on your table EQUIP REG
2. Create a filter so it has to permit you to see the data you want to move to the other table in datasheet view
3. From the menu Choose Query / Append Query and assign the table in which do you want to insert the information in question

4. Assign in the query gird in the row with Append to the correspondence of fields bn the 2 tables!

5. Click on the red exclamation mark and run the query! Confirm all questions!

6. Switch do datasheet view and mark all records that appear with the specified filter!
7. Choose delete bouton or Cut!

It's all

Best regards!

:)

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.

[kiask2343]

when I run the query it tells me that it can't append becuase of a data format error. I have done everything I can think of to clear everything and make the two fields the same but it still says it.