Only show weekly dates

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have a single column table containing dates 1/1/03 -
12/1/08 (2192 records). I have a form that's used to pick
the first date and the ending date for a query. For
example: user picks 1/1/03 beginning date and 12/31/03
ending date. The query shows, 1/1/03, 1/2/03, 1/3/03 etc.
until 12/31/03. So my query criteria is Between [Forms]!
[ReportCriteria]![BeginningDate] And [Forms]!
[ReportCriteria]![EndingDate]. Easy stuff . . .

What I really need is for the user to pick beginning date
and ending date and for the query to show the beginning
date 1/1/03 then 7 days later, 1/8/03, 1/15/03, 1/22/03,
etc... until the ending date. Not so easy stuff . . .

Any help is much appreciated. Thanks.

Alex
 
This will return the Sunday associated with the date, if you want to show
the Wednesday date (Like your example does) add 4 instead of 1

[MyDateField]-Weekday([MyDateField],1)+1
 
Thanks Darren, that is great.

Missy
-----Original Message-----
This will return the Sunday associated with the date, if you want to show
the Wednesday date (Like your example does) add 4 instead of 1

[MyDateField]-Weekday([MyDateField],1)+1

I have a single column table containing dates 1/1/03 -
12/1/08 (2192 records). I have a form that's used to pick
the first date and the ending date for a query. For
example: user picks 1/1/03 beginning date and 12/31/03
ending date. The query shows, 1/1/03, 1/2/03, 1/3/03 etc.
until 12/31/03. So my query criteria is Between [Forms]!
[ReportCriteria]![BeginningDate] And [Forms]!
[ReportCriteria]![EndingDate]. Easy stuff . . .

What I really need is for the user to pick beginning date
and ending date and for the query to show the beginning
date 1/1/03 then 7 days later, 1/8/03, 1/15/03, 1/22/03,
etc... until the ending date. Not so easy stuff . . .

Any help is much appreciated. Thanks.

Alex
Click to expand...


.
Click to expand...
 
Back
Top