Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-14-2012, 02:38 AM
jillapass jillapass is offline Multiple queries on table Windows 7 32bit Multiple queries on table Office 2007
Novice
Multiple queries on table
 
Join Date: Dec 2011
Posts: 26
jillapass is on a distinguished road
Default Multiple queries on table

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple queries on table mdb/accdb, missing tables & queries Peter J. Veger Mail Merge 1 02-23-2012 10:42 PM
Multiple queries on table Mailmerge with Access queries optiontips.in Mail Merge 2 11-21-2011 03:12 AM
Multiple queries on table Table of contents with multiple coloured headings chaka2487 Word 3 10-17-2011 01:18 PM
Multiple queries on table table spanning multiple pages 'upside down' 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft