G
Guest
I have a query to select records for printing a report. Sometimes I want all
the records, and sometimes I want a particular one. To choose the particular
one, I enter the ID in an unbound box on the form. When that box is null, I
want all of them. I put the following criteria in the query:
nz([Forms]![Main]![Print_form].[Form]![PrintIDtoPrint],">1")
This works when I enter the ID in the box, but when the box is null, the
">1" returns no records. If I put >1 by itself in the Criteria it returns
all the records, and if I type a valid record number in the nz function in
place of the ">1" it returns that record. Is there any way to make this
work? Thanks.
David
the records, and sometimes I want a particular one. To choose the particular
one, I enter the ID in an unbound box on the form. When that box is null, I
want all of them. I put the following criteria in the query:
nz([Forms]![Main]![Print_form].[Form]![PrintIDtoPrint],">1")
This works when I enter the ID in the box, but when the box is null, the
">1" returns no records. If I put >1 by itself in the Criteria it returns
all the records, and if I type a valid record number in the nz function in
place of the ">1" it returns that record. Is there any way to make this
work? Thanks.
David