Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update table using other table's info

Status
Not open for further replies.

New2This

Programmer
Apr 9, 2002
4
CA
Hi
I have a table CustOrder in where a field called RequiredDate needs to be updated. This table holds all orders for customers (CustID). Within this table there is a field called ReleaseNo. The tables are as follows

ReleaseDates:
ReleaseNo
PostalCode
ReleaseDate


Customer table:
CustId
Name
Address1
PostalCode

CustOrder:
CustID
OrderNo
ReleaseNo
RequiredDate

For each order a RequiredDate must be entered based on the ReleaseNo and the customers PostalCode. Every field in each of these tables are filled except the RequiredDate field.
I thought I would write an update query to fill it with the proper dates based on the above criteria

How how how do I right the update query
Seriously stuck

thanks
Mary
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top