By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,709 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,709 IT Pros & Developers. It's quick & easy.

Parameter Like Statement Criteria Problem

P: n/a
I am having difficulty with a MS Access XP (2000 based) paramter query
linked to a mainframe. The query has
Like "*" & fgMyVariable()&"*"
in the criteria but does not return any records althoght the table is
populated. The query DOES however return records on Access 2000 with
the SAME query. No records return if the user enters data in the
parameter or leaves it blank on Access XP.

Any suggestions?

These are make tables from an old mainframe, using Jet to cycle data
on local workstataion from File Server.

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.