Append Query Help - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Append Query Help

Christopher Laidler

2 years ago

I have a vehicles table in my database that I want to update from a linked stock list table and I want to be able to set the field customer order (yes/no) to match what is in the linked table and also to set the value to true if the vehicle is no longer in the linked stock list table.

Thank You.

	Richard Rost @Reply 2 years ago
Going to need a LOT more detail than just this in order to help you. Let's start with some screen shots.

	Christopher Laidler OP @Reply 2 years ago

	Christopher Laidler OP @Reply 2 years ago

	Christopher Laidler OP @Reply 2 years ago
There is a customer order field in the Vehicle Table which i want to set to true if the matching record by stock number in the linked table (csv file from another system) is set to true and also if the stock number does not appear in the linked table anymore due to vehicle being sold to mark the customer order field to true in the vehicle table - thank you

	Richard Rost @Reply 2 years ago
Since I don't know your skill level, are you familiar with update queries? Update Queries

	Christopher Laidler OP @Reply 2 years ago
Yes I have been following your query videos however I get an error when running the update query I have attached some images to help explain not sure what I'm doing wrong.

	Christopher Laidler OP @Reply 2 years ago

	Christopher Laidler OP @Reply 2 years ago

	Kevin Robertson @Reply 2 years ago
Import the CSV file instead of linking to it and your Update Query should work.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View