Entering variable dates into Query which a Summed query is based on

W

Will

I have a query qryStockTransfers which is made up of tblTransfer and
tblTransferDetails (One to many). It shows TransferID, TransferDate,
ProductNo, WarehouseFrom, WarehouseTo and Quantity. I have another query
(qryStockTransfersSummed) based on qryStockTransfers that pulls the
ProductNo, WarehouseFrom, WarehouseTo and sums the quantity. I have created
a form from qryStockTransfersSummed and made an option group with the
options today, yesterday, last week and date range. I have tried adding to
the criteria of the TransferDate Parameters & referencing to the form but
can't get it to work. Any suggestions?

Thanks in advance
 
Top