Hello all!
I have a report that groups weeks for me, but I need to modify the dates beyond week 1 of the year, etc. (If you really want to throw me a bone, our week runs Friday-Thursday).
The code below works when Access tells *me* the date range, but what if I want to tell *it* what dates to look at?
The Field Name is [Tour Date] -- What do I add to the Control Source to make it only look at tour dates from January 5th, 2007 to January 11th, 2007?
=-Sum(IIf([Hilton Head]=True,[Full Down])*[Purchase Price])/-Sum(IIf([Hilton Head]=True,[Toured]+[Not Qualified]))
(((((((and how do you make the report show the dates it's determining on it's own?))))))))))))))
I have a report that groups weeks for me, but I need to modify the dates beyond week 1 of the year, etc. (If you really want to throw me a bone, our week runs Friday-Thursday).
The code below works when Access tells *me* the date range, but what if I want to tell *it* what dates to look at?
The Field Name is [Tour Date] -- What do I add to the Control Source to make it only look at tour dates from January 5th, 2007 to January 11th, 2007?
=-Sum(IIf([Hilton Head]=True,[Full Down])*[Purchase Price])/-Sum(IIf([Hilton Head]=True,[Toured]+[Not Qualified]))
(((((((and how do you make the report show the dates it's determining on it's own?))))))))))))))
