filter by query

  • Thread starter Thread starter Jeff @ CI
  • Start date Start date
J

Jeff @ CI

In A2K, I have a form with two calendar controls. One for a start date, one
for an end date - both have text boxes that get the dates clicked - TxtBegin
and TxtEnd. I have three buttons that hit nearly identical queries (same
fields but present differing data) for the three buttons. I filter the date
in the queries all the same - >=[Form]![Confirmations].[TxtBegin] and
<=[Form]![Confirmations].[TxtBegin]. The reports have no filtering criteria
and the filter is turned off. With two reports, I get the information
filtered as desired. On one, I cannot get the report filtered at all. I
have tried to filter only by report using the report properties, I have tried
to use 'pop-up' text boxes to enter the dates and I still get all the
information instead of the desired date range.

Any ideas - many thanks in advance.

Jeff
 
Minor correction - the criteria for the filter in the queries is
=[Forms]![Confirmations].TxtBegin] and <=>=[Forms]![Confirmations].TxtEnd].
Click to expand...


Jeff @ CI said:
In A2K, I have a form with two calendar controls. One for a start date, one
for an end date - both have text boxes that get the dates clicked - TxtBegin
and TxtEnd. I have three buttons that hit nearly identical queries (same
fields but present differing data) for the three buttons. I filter the date
in the queries all the same - >=[Form]![Confirmations].[TxtBegin] and
<=[Form]![Confirmations].[TxtBegin]. The reports have no filtering criteria
and the filter is turned off. With two reports, I get the information
filtered as desired. On one, I cannot get the report filtered at all. I
have tried to filter only by report using the report properties, I have tried
to use 'pop-up' text boxes to enter the dates and I still get all the
information instead of the desired date range.

Any ideas - many thanks in advance.

Jeff
Click to expand...
 
Back
Top