query issue

[defosset]

I need to get data from the intro time field from my CDData2 table and I need to match it up to records in my New Music Query and it needs populate the matching records in that table In the intro time field in New Music Query, when I attempt this it either turns out blank and no records or doubles or eventriples the records.

here are the fields in both table.

Slot Number Song Title Artist Track Number Song Time Album Title Year

 

[JonFer]

Please post an example of your SQL.

What combination of fields indicates a unique record in each of the tables? SlotNumber and TrackNumber?

John

http://www.interautomateconsulting.com

 

[defosset]

I got It to work but I now need to take data from that table and match it against it data from another table, the fields are the same in both tables and what I need to do is set a query to remove all data from table #2 that is already in Table #1 then when ever is still displayed in table 2 it needs to be added to table one.

 

[PHV]

remove all data from table #2 that is already in Table #1
DELETE [table #2.#] FROM [table #2] INNER JOIN [table #1] ON your join condition(s) here

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lespaul]

why would you need to do so much copying and deleting and moving of records in the first place?

Leslie