Totaling Number of Instances Using a Calander

  • Thread starter Thread starter malix02
  • Start date Start date
M

malix02

Guest
I am still a novice as Acces but have developed a nitch for the access programming. However I cannot figure out this one thing. I need to get a total by day and date range. Let me be more specific. I first need to specify a date range and count how many days total including the first and second day. For Example July 3rd to July 16th would be 14 days. Then I need to specify how many to order each day of the Week. For example if a client wanted to order 2 items every mon-fri I need to specify 2 on mon, 2 on tue. ect...ect....And the last spet I need is to calculate the total to order each day by date range. For Example if my client want to order 2 ever monday thru friday between July 3rd and July 16th it should total 20. Sorry so long winded. Anyone got any Ideas?
 

Users who are viewing this thread

Back
Top Bottom