D dspinner Registered User. Local time Today, 20:44 Joined Sep 26, 2002 Messages 16 Sep 15, 2005 #1 I have created a table where people enter dates that they are "booked". I want to create a query to find those who are NOT booked on a certain date. Please help
I have created a table where people enter dates that they are "booked". I want to create a query to find those who are NOT booked on a certain date. Please help
freakazeud AWF VIP Local time Today, 16:44 Joined Sep 10, 2005 Messages 221 Sep 15, 2005 #2 Hi, so you mean the ones which do NOT have a value in the date field? Use Is Null in the criteria of the query date field! HTH Good luck
Hi, so you mean the ones which do NOT have a value in the date field? Use Is Null in the criteria of the query date field! HTH Good luck