Finde den aktuelle booking

nogen der har et godt indspark til denne problematik :-)

Not sure how your using your filters but if you have your filter fields on a form then you could build you sql query dynamically depending on what fields are entered.

EG
You have a start date and an end date but only enter start date

.. WHERE DateField >= StartDate ..

and if you also enter an EndDate

.. WHERE DateField >= StartDate AND DateField <= EndDate

And if you only enter and EndDate
.. WHERE DateField <= EndDate


So its much more flexible than having to enter both dates

Hej Terry !

Endnu en gang fik du mig på ret kurs .. 1000 tak for det

her er min kode, der virker nu :
også så andre kan få glæde af idéen :
mvh martens

kode :
SELECT Current_bookings.BokNr, Current_bookings.RegNr, Current_bookings.StartDate, Current_bookings.StartTime, Current_bookings.EndDate, Current_bookings.EndTime, [Enddate]-[startdate] AS [Booket i X antal dage], Current_bookings.Notes, Current_bookings.[Car Pool], Current_bookings.Drivers, Current_bookings.Company
FROM Current_bookings
WHERE (((Current_bookings.RegNr)=[Forms]![frm_select_cars]![REGNR]) AND ((Current_bookings.StartDate)<=Date()) AND ((Current_bookings.EndDate)>=Date()));

Hi Ole good to see you got something working although I'm not sure how it finds anything with the where you give in example

Maybe be wrong but isn't it finding everything for specific REGNR?

det virker i hvert fald som det skal og en bil ( REGNR ) kan jo kunne have en booking ad gangen ....

Well you obviously know what you want better than me. Just found it strange with the date interval, from what I can see it looks as though it selects ALL dates less than and greater than and = date().
Anyway whats important is its working for you ;-)