View Single Post
  #2  
Old March 30th, 2010, 04:24 PM posted to microsoft.public.access.gettingstarted
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default 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