Dear Forumers,
Thank you again for the help so far. I am relatively new to Access but need to get some things done fast, so appreciate the help.
Suppose I want to update/modify a table called Sheet1 based on results fromm queries Query1, Query2, and Query3.
Here is what I want to do:
1) Add a new column to Sheet1, called Code.
ALTER TABLE Sheet1 ADD COLUMN Code Text(10)
.....somehow I am getting a "query must have a destination field" error from the add column SQL above. Any thoughts into why there is an error?
2) Run Query1. Then update newly created Sheet1 Column called 'Code'...so that for all Sheet1 recordes returned by Query1, set Code = 'Green'.
3) Run Query2. Then update Code column in Sheet1 so that for all records returned by Query2, set Code = 'Green'.
4) Run Query 3. Query 2 and Query 3 may return the same records in some instances. If record falls under Query 3 BUT NOT in Query 2, then set Code = 'Yellow' for record. Else, do nothing.
5) For all records in Sheet1 not in Query1, Query2, and Query3, set Code = 'Red'.
How can I go about accomplishing steps 1-5 above?
Much Appreciated!