Filter property

[ehunter]

Hi,

I am trying to run a report with a filter on the data using the property
window. The data is coming from a query named PCI.

The Record Source SQL is: SELECT PCI.FIELD_TEAM, PCI.[Net Merch],
PCI.[PCI/STI] FROM PCI;
The Filter is: ((PCI.PCI/STI)='STI-unroaded')

When I try to run the report, I get a pop-up with PCI.PCI and a text box to
enter a parameter.

I don't understand because I'm sure I have created similar filter strings in
the past. It's like it's not recognizing PCI as the query and PCI/STI as the
filter field. Am I missing something?

THANKS!

 

[Duane Hookom]

You shouldn't need the table name in the filter string. Try:
[PCI/STI]='STI-unroaded'