#Name? Issue when narrowing down query

[ijswalker]

Hi,

I am having an issue with my query. When I link all of my tables together and run my query I return the lines I need. However, When I narrow down the search - for example- PO_Date then I get the following error mesage in the fields after the query has run #Name?. If I take this same query to a different computer then it works ok. This query is a stand alone query and not connected to any form.

Thanks in advance for your help,

Ian

 

[vbaInet]

1. What are the differences between your computer and the other computer that works? Access version and OS type?

2. Can you show the sql of your query?