I'm not well versed in SQL, but it seems to me there should be an equivalent of tblBookingsWarehouse.Wk_Com (maybe tblBookingsWarehouse.Wk_Com=*) that applies to all records in the table. That should enable you to extract all records for the matched clients.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|