W
Warden
I am trying to create a chart using data from a query. I am trying to plot
how many different products are received by each week. the products come in
on a daily basis and a date is entered for each item. when I try to get the
chart to show the number of items received each week i get the week number of
the year. for example for items received Jan1 through jan 7 the axison the
chart just list 1, then 2,3....for each addition week. how can i get the
chart or query to group every thing by the last day of the week, and show the
date.
how many different products are received by each week. the products come in
on a daily basis and a date is entered for each item. when I try to get the
chart to show the number of items received each week i get the week number of
the year. for example for items received Jan1 through jan 7 the axison the
chart just list 1, then 2,3....for each addition week. how can i get the
chart or query to group every thing by the last day of the week, and show the
date.