Hi there, Hoping someone can help. Here is what I need to do. I want to use a query to update one field with the text from another field from the query with criteria. It may work something like this: (SELECT [PurchaseOrderLineId] FROM [qryPartWeightAssign] WHERE [Assign] FROM [dbTicketLineItems] = -1) AND [PartNumberID] FROM [dbPurchaseOrderLineItems] = [PartNoID] FROM [dbTicketLineItems] Then I want to append or update it to the proper table [dbTicketLineItems]. I am a complete beginner at sql and doing update queries or append queries. Please let me know if anyone can help.