How do I build an interactive report that inserts 2 different dates into this expression?
SELECT *
FROM Activity
WHERE DATE BETWEEN #5 / 1 / 03# AND #5 / 29 / 03#
I know how to build the interface but how would I link the form that asks for the dates and the dataenviroment?
Thanks,
Nir
SELECT *
FROM Activity
WHERE DATE BETWEEN #5 / 1 / 03# AND #5 / 29 / 03#
I know how to build the interface but how would I link the form that asks for the dates and the dataenviroment?
Thanks,
Nir