Interesting Problem

[pinecrest515]

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 from 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)

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!

I don't have much experience with VB on Access, so any detailed pointers would be appreciated.

[weekend00]

you questions are always INTERESTING.
I am interested in you questions.

but maybe i am not good enough to solve your problem, and make you keep posting new threads.

So i am not going to respond to this thread so that other others can help you out.