query for "events during the week beginning...."
Try this in the criteria for your date field:
Between [week beginning dd/mm/yyyy] And [week beginning dd/mm/yyyy] + 6.99999
Make sure to define [week beginning dd/mm/yyyy] as a Date/Time field in the
parameter box. It should only prompt you for the date once.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Kathryn" wrote:
Is it possible to set a query to list events with a parameter "week beginning
dd/mm/yyyy" - or do we have to use between two dates a week apart?
Many thanks
|