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?