One parameter for various columns of dates

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.

.

Relevant Pages

  • Re: Rewrite a WHERE clause
    ... Can you use my query above and ... fit it to your example? ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: difficult summing query
    ... this sort of thing is exactly what I need. ... the query you gave to fit the particular table names, etc, I now have ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • designing a report
    ... I need to create a report from a query. ... not seem to fit them in there nicely. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Update Query; But keep rest of field...
    ... Using the Design View to create a query, ... UPDATE tblItem SET tblItem.itemMfgItemNumber = "Fit ABS" ... The goal is to find all items that START with "Fitting ABS" and change them ... Fitting PVC Sch40 1" 90 ELL SxS ...
    (microsoft.public.access.queries)
  • Re: Update Query; But keep rest of field...
    ... Using the Design View to create a query, ... UPDATE tblItem SET tblItem.itemMfgItemNumber = "Fit ABS" ... Fitting PVC Sch40 1" 90 ELL SxS ...
    (microsoft.public.access.queries)