![]() |
#1
|
|||
|
|||
![]()
I am trying to create a report as follows, but don't know how to.
I have a list of bookings and I find all the bookings for a particular week. No problem there. Then, I want to use the client for each of these bookings and find out all the bookings previously for this client, but only for clients who have a booking for the specified week. So, to clarify, for next week I have 127 bookings and for each of these bookings I want to see if the client has booked previously. Currently I am just finding the bookings for the specified week, but don't know how to do the 2nd query. I guess what I need is to do a 2nd WHERE statement which is different from the 1st one, but on the same table. Thanks fir any help. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Peter J. Veger | Mail Merge | 1 | 02-23-2012 10:42 PM |
![]() |
optiontips.in | Mail Merge | 2 | 11-21-2011 03:12 AM |
![]() |
chaka2487 | Word | 3 | 10-17-2011 01:18 PM |
![]() |
lj_eco | Word Tables | 13 | 07-17-2011 04:39 PM |
mail merge queries not displaying | donwalt | Mail Merge | 0 | 09-05-2010 02:41 PM |