Parameters in criteria

[kashew]

I've got a parameter value called [REGION] as a field criteria. When I execute the query and input the parameter value in the dialog box, I get no data. If I replace the [REGION] parameter in the criteria field with the actual value that I types into the dialog box, I get data. Does anyone know what I am doing wrong? I am querying an Oracle database if that makes any difference.

 

[pdldavis]

Hi, if I understand you correctly, you have a field in a query named xyz and you want to display results by using 'Region', which is in the criteria section of the query. If that is the case, use [Region?]. The user then types in the region. It should work fine.
Hope that helps.

 

[kashew]

Yes, you understand correctly. What you suggest is what I've done and it does not work for some reason on my Oracle database. I've done this with Sybase database with no problem. There is obviously something different about Oracle. When I replace [Region?] with a value "North" in criteria, the query will return data.

There must be someone out there that has solved this problem.

 

[WildHare]

Does Oracle, or your implementation of it, perchance differentiate between NORTH and North?.....

I know Access doesn't care, but I thought I remembered seeing something somewhere about a user-definable something that you could set that WOULD case-differentiate in Oracle tables. Remember, you're unique - - just like everyone else
Another free Access forum:

http://www.forumco.com/jmhare

http://www.jmhare.com