Help please with append query.

A

alecgreen

Hi All

I have three tables:

tblColour: containing the fields StockNo & Colour
tblJobs: containing the fields StockNo, JobNo etc...
tblJobStatus: containing the field JobNo, Colour, Jobstatus etc...

I have a select query that links tblColour & tblJobs to give me the
fields JobNo,StockNo & Colour. From this query I want to append (or
update?) the Colour field from the query to tblJobStatus, thus making
the colour dependant on the JobNo rather than the Stock No. This is
necessary as most jobs will be the standard colour as in tblJobs - but
thats not all the time!

Many Thanks

Alec
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Append/Update Query 1
Status update query 1
HELP!! Query driving me mad!! 2
Need help getting specific records with SQL 4
Select / Append Query 1
Combo box with same table source 5
Help with Append Query 1
Tables and Relationships Help! 3

Top