Query help

K

ken_d128

I would like to create a query from 2 tables and find the common dates
of each shipDate and shipRepair date to popuplate a form

First table is Order which has all the order info

JobNo
CustNo
Cust
JobAddress
ShipDate

Second Table is Repair
This is from the many side of Oder Table
It is connected JobNo

RepairNo
ShipRepairDate

So I could have example 10 Orders and 2 Repairs Shipping on same Day
Looking to have one field for both dates on form to show all Orders and
repairs
for particular date
any sugestions is apprecieated
thanks
Ken
 
A

Amy Blankenship

Don't use the reserved word Order to name tables, fields, reports, etc.

Select * FROM tblOrder INNER JOIN Repair ON tblOrder.JobNo = Repair.JobNo
WHERE tblOrder.ShipDate = [Enter the date you want to see]

HTH;

Amy
 
Top