W
Wade Taylor
I have a table that has 4 columns which contain dates. I set up a query that
has those dates in it and want one parameter to search for the date ranges in
each of those columns.
So basically I want to be able to type a beginning date (i.e. 1/1/00) and
ending date (i.e. 1/1/01) in a parameter and have that display the dates from
each column that fit that criteria.
I can get it to work for one column of dates that fit the parameter that I
have set. But I cannot figure out how to have one parameter work for all of
the columns containing dates. If you have any ideas or suggestions on how to
have one parameter for various fields it would be greatly appreciated.
Thanks.
has those dates in it and want one parameter to search for the date ranges in
each of those columns.
So basically I want to be able to type a beginning date (i.e. 1/1/00) and
ending date (i.e. 1/1/01) in a parameter and have that display the dates from
each column that fit that criteria.
I can get it to work for one column of dates that fit the parameter that I
have set. But I cannot figure out how to have one parameter work for all of
the columns containing dates. If you have any ideas or suggestions on how to
have one parameter for various fields it would be greatly appreciated.
Thanks.