J
Jason G
I have a Base query that I need to filter down via a Form. This form
has 21 options (date, Drop-down boxes, Check boxes) that can be used to
filter the data in my base query down for a report.
My Users have the ability to select a Type of form, whether or not that
form was completed or its due tate was extended and by what date either
by year or month or specfic date either of these acitivites were
completed. They also have the ability to filter by Client Priority or
Form Priority and select weather not nor to show Hidden or Non-Hidden
Records.
I need each of these options to be applied to this base query data
without any of the other options blocking the results of the selected
options. In othe words if the option isn't selected ignore it.
However, if a user wants to see completed forms the query should also
report forms that may or may not be extended even if the extended check
box option is not checked.
Any help would be great !
has 21 options (date, Drop-down boxes, Check boxes) that can be used to
filter the data in my base query down for a report.
My Users have the ability to select a Type of form, whether or not that
form was completed or its due tate was extended and by what date either
by year or month or specfic date either of these acitivites were
completed. They also have the ability to filter by Client Priority or
Form Priority and select weather not nor to show Hidden or Non-Hidden
Records.
I need each of these options to be applied to this base query data
without any of the other options blocking the results of the selected
options. In othe words if the option isn't selected ignore it.
However, if a user wants to see completed forms the query should also
report forms that may or may not be extended even if the extended check
box option is not checked.
Any help would be great !