Multiple queries on table

jillapass · #5 09-17-2012, 01:29 AM

Sorry, wk_com is a date of start of booking.
It wouldn't make much sense to attach the workbook as the data is in an SQL database so all the workbook contains is a list of bookings for a specified week with the client number and carer number, nothing else at all.
So, the select finds the bookings for a week, I then want to find any previous booking for clients that are already in this list, but these are in the same table.

The query I have is:

Code:

SELECT tblBookingsWarehouse.Wk_Com, tblBookingsWarehouse.CarerNo, tblBookingsWarehouse."Client Number"
FROM ch_warehouse.dbo.tblBookingsWarehouse tblBookingsWarehouse
WHERE (tblBookingsWarehouse.Wk_Com=?) AND (tblBookingsWarehouse.Type='Booking')
ORDER BY tblBookingsWarehouse.CarerNo

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