Filtering Question

[viperstingray]

Hi. I was just wondering if it is possible to filter out records in a report using a filter...but here is the trick. Is it possible to filter them EVEN if the coulmn is not included in the report.
EX:
NAME----ID-----Job type-----Cost----Rebate

can I sort them by "JOB APPROVAL" even if that column is not in the report?
if I can, how would i go about doing that?

 

[Brianwarnock]

shouldn't you be fiktering at the query level?

 

[viperstingray]

this might be a bit of a shocker...I don't have any queries. I tried them but I found it easier to work without them. So far, I have not run into any troubles.

 

[Brianwarnock]

If you say so.

Your post is titled filtering but you quote a sort as your example. Both are ok as asked , but wouldn't it have been quicker to try?

Brian

The filter is in the reports property sheet you sort using the sorting and grouping feature

 

[viperstingray]

Sorry about that. I meant FILTER. Can i filter out the records that I do not require even if their fields are not in my report?

 

[Brianwarnock]

Yes using the filter property in the forms property sheet, but this means going into report design each time that you want to change the filter, using a query the filtering can be done from form input.

Brian

 

[Taurus05]

Hi,

I am new to the filter property. How do u use them? Looking at the help assistant, it give the example of me.filter = "Country = 'USA'". Shouldn't it be [Country]= "USA". This does not work at all.

Can anybody highlight to me? Thanks in advance.

 

[Brianwarnock]

If you are using VBA code to set the filter the ACCESS help syntax is correct
If you are using the reports property sheet then country='USA' is correct.

remember to turn the filter on either in the property sheet or via VBA

Brian