Query help date format

[icemac]

In my BookingTable I have a StartDate (Format: "dd/mm/yyyy"). For every start date there is a CostOfBooking field also in the query. I want to show a list of all the current StartDates that occur in this month of this year and the cost of that booking. How can this be done?

 

[ColinEssex]

In the StartDate criteria put

Between 01/01/2007 and 31/01/2007

Col

 

[Bat17]

something like this should let you filter for the current month

Between DateSerial(Year(Date()),Month(Date()),1) And DateSerial(Year(Date()),Month(Date())+1,-1)

peter