O
Oldgeek
Hi I'm creating a stock and sales report, on two seperate tables, then put
into a query together. The query pulls through all my sales information by
week by store for each product, but my stock information by product by week
by store appears in the query with the stock values grouped together, even
when I select the stock values to be displayed as "SUM" in the design view.
how can I get the query to display the stock values by week for each product.
is there an expression I can use to select only the most recent 4 weeks when
the query is run?
Please help totally lost now when I thought everything was going well
into a query together. The query pulls through all my sales information by
week by store for each product, but my stock information by product by week
by store appears in the query with the stock values grouped together, even
when I select the stock values to be displayed as "SUM" in the design view.
how can I get the query to display the stock values by week for each product.
is there an expression I can use to select only the most recent 4 weeks when
the query is run?
Please help totally lost now when I thought everything was going well