how to show of hide data in a report

  • Thread starter Thread starter JMG
  • Start date Start date
J

JMG

Hi,
I have a query with names and 4 dates. I filtered the
query so I have only the names with Today's date. Howerver
in the report I have the names and the 4 dates, I just
want the name and its respective Today's date.

xxxxxx 12/11/03 05/05/03 01/02/03 07/06/03
yyyyyy 11/20/03 04/20/03 03/03/03 01/02/03
zzzzzz 01/01/03 05/06/03 08/09/03 11/20/03

today is 11/20/03
I filter
I get this in the report:

yyyyyy 11/20/03 04/20/03 03/03/03 01/02/03
zzzzzz 01/01/03 05/06/03 08/09/03 11/20/03

And I want this:
yyyyyy 11/20/03
zzzzzz 11/20/03

Thank you very much!!
 
Presumably your query includes a WHERE clause such as:
WHERE ((Field1 = Date()) OR (Field2 = Date())
OR (Field3 = Date()) OR (Field4 = Date()))

In your report, change the Control Source of the text boxes to something
like this:
=IIf([Field1] = Date()), [Field1], Null)
Change the Name to something like:
txtField1
The name must not the the same as a field when it is bound to an expression.
 
Back
Top