Form to Filter Report by Week Number

[jortizz]

I'm trying to get my form to run a report based on Week Numbers. My company has weekly sales data based on a 4-4-5 Calendar (First month has 4 weeks, Second month has 4 weeks, and third month has 5 weeks). I'm trying to run reports to compare last year vs this year by YTD, Month to Date, and by a Week Range. The original data has a WeekNumber field (1-52) which I would like to use to compare sales data.



How should I design my form/query to show this data? I would like to give the user a range to filter their report, ie. a StartWeekNumber and EndWeekNumber and have my report display only those weeks.

Thank you.

[NTC]

Well you state that: The original data has a WeekNumber field (1-52) - - - and so this is a hugely important starting point that makes your life alot easier.

To pull reports by a specific week is a simple query with that value as criteria. If this isn't clear then you want to get yourself an Access textbook easily found at Amazon or any large book store and read up on query design.