pls help
how can i make my system database auto detect if a truck pickup (B.O. products)on schedule(day).....
all pickups are encoded daily......
store #-- store name--- pickup sched (monthly) -- no 0f B.O.(quantity)
1 ------- mystore1 ----- -every monday -- -------------- 3
2 ------- mystore2 --- -- mon-fri -- --------------------
3 ------- mystore3 -------thurs wk1 & thurs wk --------
4 ------- mystore4-------tues wk1 & tues wk4 --------
5 ------- mystore5 ------ sat & sun -- -----------------

the output will be on a report scorecard
wk1
month 1 --------------m------t------w------th------f-----sat-----sun
store # storename --date1--date2--date3--date4--date5--date 6--date7
1 -------store1 ------y
2 -------store2 ----- y ------ n----- y------ n------ x
3 -------store3 -----------------------------y
4 -------store4 ------------- y
5 -------store5 ------------------------------------------- y------ y

where y=on sched w/pickup (B.O.)
n=on sched but zero pickup(zero B.O.)
x=none visit of truck