Filter property

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
You shouldn't need the table name in the filter string. Try:
[PCI/STI]='STI-unroaded'
 
Back
Top