I would suggest scrapping the SQL approach and just use a DLookup function. Search for it in Access help for some great information.
I would suggest scrapping the SQL approach and just use a DLookup function. Search for it in Access help for some great information.
-Randy Shea
I'm a programmer, but I'm also pro-grammar!
If your issue is resolved, please use Thread Tools to mark your thread as Solved!
PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003
Posting Permissions
Reply With Quote