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

Query Works in A97 and Not in A2003

P: n/a
Hi,

I have a query that runs smoothly in an Access 97 database, but fails
when it runs in Access 2003. (The original database was created in 97
and converted to 2003, if that makes a difference.)

Here is SQL statement that fails in Access 2003.

SELECT DISTINCTROW tblPhysDirectory.phyLastName
FROM tblPhysDirectory
WHERE (((tblPhysDirectory.phyLastName) Like
"|[Forms]![frmPhysDirectorySearch]![FindLName]|*"))
ORDER BY tblPhysDirectory.phyLastName;

Any help you can lend with this would be appreciated.

Henry

Aug 29 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Henry Stockbridge" <hs***********@hotmail.comwrote in
news:11*********************@b28g2000cwb.googlegro ups.com:
Hi,

I have a query that runs smoothly in an Access 97 database,
but fails when it runs in Access 2003. (The original database
was created in 97 and converted to 2003, if that makes a
difference.)

Here is SQL statement that fails in Access 2003.

SELECT DISTINCTROW tblPhysDirectory.phyLastName
FROM tblPhysDirectory
WHERE (((tblPhysDirectory.phyLastName) Like
"|[Forms]![frmPhysDirectorySearch]![FindLName]|*"))
ORDER BY tblPhysDirectory.phyLastName;

Any help you can lend with this would be appreciated.

Henry
It should not have worked in 97 either, as written, but replace
"|[Forms]![frmPhysDirectorySearch]![FindLName]|*"
with [Forms]![frmPhysDirectorySearch]![FindLName] & "*"

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Aug 29 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.