you're filling up my box. stick to the post
Quote
SELECT [tblBooking-Airwaybill].[Cargo Booking #], [tblBooking-Airwaybill].[Airway Bill #], [tblBooking-Airwaybill].[Qty Booked], tblAirwayBill.[Package Size], tblAirwayBill.[Sales Price], [tblBooking-Airwaybill]![Qty Booked]*[tblAirwayBill]![Sales Price] AS [Extended Price]
FROM tblAirwayBill INNER JOIN [tblBooking-Airwaybill] ON tblAirwayBill.[Airway Bill #] = [tblBooking-Airwaybill].[Airway Bill #];
what is that supposed to accomplish vs what do you expect it to get?
btw you need better column names. dont use spaces or # so we can avoid [] all over the place
/edit: looks like you're not responding anymore, and i'm overdo for sleep.
This post was edited by carteblanche on Nov 17 2014 02:54am