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 - 31 Aug 2006 17:22 GMT
You shouldn't need the table name in the filter string. Try:
[PCI/STI]='STI-unroaded'

Signature
Duane Hookom
MS Access MVP
> Hi,
>
[quoted text clipped - 16 lines]
>
> THANKS!