i have a report that tracks customer contacts by salespeople at a car
dealership. the contacts are assigned several values, one of which is the
date that they came in. the report is capeable of being run to any date
range specified by the user, which is a key feature for training of new
employees (ergo, changing this is not an option). the report is based on a
table of these contacts but in a few of its controls, does some dlookup,
dcount and dsum expressions to pull data from a table of sold cars. the
problem is this. the table of sold cars is created with monthly data. it is
not important for my facility to track the DATE the car was sold for the
purposes of this report. most of the time, in fact, the report will be run
on a whole month's data at one time. when this happens, the d-functions will
pull the # of sales for each salesperson for that month. if it's a 3 month
period of time, it works just as well as 1 month or 20 months. So here's the
problem: if someone wanted to run a report for a period of time that is not
either from the first day of a month or ending at the last day of a month,
how can i set up the visible property of some of these expressions to be
false? in more detail:
if txtboxstartdate = 10-1-05 and txtboxenddate = 10-31-05 then these controls
should be visible.
if txboxstartdate = 05-1-03 and txtboxenddate = 10-31-05 then these controls
should be visible.
if txtboxstartdate = 11-15-05 or txtboxenddate = 12-4-05 then these controls
should not be visible.
basically, how do you write an expression that evaluates two text boxs that
are formatted as mm/dd/yyyy to be whole month values or not? sorry if this
was wordy. thanks for looking.
--
Message posted via http://www.accessmonster.com