Retrieve records on a report

  • Thread starter Thread starter Pedro
  • Start date Start date
P

Pedro

Hi everyone
How can i retrieve some records, like [Thisfiled]>0 in a
filter? My access version is 2002.
Tks in advance
Pedro
 
Just put that criteria into the query upon which your report is based. In
the column for your field in the criteria space just put >0


Rick B


Hi everyone
How can i retrieve some records, like [Thisfiled]>0 in a
filter? My access version is 2002.
Tks in advance
Pedro
 
What if that field does not and can not exist on that
query? I had to make another field to show me a result.
Can i, for example, in the filter of properties say like =
[Text138]>0 ?

Tks in advance
Pedro
 
Yes, you could do it in the Report Filter. I am not as good at that though.

Could you not add the field to your query? What are you putting in that
field? Queries can contain calculated fields as well. And then, you can
test on them.



Rick B


What if that field does not and can not exist on that
query? I had to make another field to show me a result.
Can i, for example, in the filter of properties say like =
[Text138]>0 ?

Tks in advance
Pedro
 
That field is working on a total area and i've tried to do
it first on qry and it didn't work. Do you know how to do
it on that filter report? Cose it's not working a simple
solution like : =[Text138]>0 (only positive values)
Any ideas?
Tks in advance
Pedro
-----Original Message-----
Yes, you could do it in the Report Filter. I am not as good at that though.

Could you not add the field to your query? What are you putting in that
field? Queries can contain calculated fields as well. And then, you can
test on them.



Rick B


What if that field does not and can not exist on that
query? I had to make another field to show me a result.
Can i, for example, in the filter of properties say like =
[Text138]>0 ?

Tks in advance
Pedro
-----Original Message-----
Just put that criteria into the query upon which your report is based. In
the column for your field in the criteria space just put >0


Rick B


Hi everyone
How can i retrieve some records, like [Thisfiled]>0 in a
filter? My access version is 2002.
Tks in advance
Pedro


.
Click to expand...


.
Click to expand...
 
Back
Top