If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Retrieve records on a report
Hi everyone
How can i retrieve some records, like [Thisfiled]0 in a filter? My access version is 2002. Tks in advance Pedro |
#2
|
|||
|
|||
Retrieve records on a report
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 "Pedro" wrote in message ... Hi everyone How can i retrieve some records, like [Thisfiled]0 in a filter? My access version is 2002. Tks in advance Pedro |
#3
|
|||
|
|||
Retrieve records on a report
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 "Pedro" wrote in message ... Hi everyone How can i retrieve some records, like [Thisfiled]0 in a filter? My access version is 2002. Tks in advance Pedro . |
#4
|
|||
|
|||
Retrieve records on a report
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 "Pedro" wrote in message ... 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 "Pedro" wrote in message ... Hi everyone How can i retrieve some records, like [Thisfiled]0 in a filter? My access version is 2002. Tks in advance Pedro . |
#5
|
|||
|
|||
Retrieve records on a report
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 "Pedro" wrote in message ... 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 "Pedro" wrote in message ... Hi everyone How can i retrieve some records, like [Thisfiled]0 in a filter? My access version is 2002. Tks in advance Pedro . . |
Thread Tools | |
Display Modes | |
|
|