filter by query

[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

 

[Jeff @ CI]

Minor correction - the criteria for the filter in the queries is

=[Forms]![Confirmations].TxtBegin] and <=>=[Forms]![Confirmations].TxtEnd].

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