wanna know syntax to search a date field in table

[waiwainoo]

i have a table known Reservation ... and one of its field is Party_date ... one other field is Booked_tables.

I want that when user input the date on form ... all dates in field Party_date should be selected which is equal to the inputted date ... and the number of booked tables should add up.

plz tell me how can i make a query for this.

Thanks

 

[Eupher]

waiwainoo -

Create your query in the query builder grid. One of your columns will be Party_date. In the criteria field for that column, enter:
[tt][Forms]![MyForm]![MyField][/tt]
Where "MyForm" is the name of your input form and "MyField" is the name of the field on the form into which the user is entering the desired date. The form must be open when the query is run for this to work.

HTH

Ken S.