Can join tables in query on calculated field. Just can't set a Relationship.
Can join tables in query on calculated field. Just can't set a Relationship.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
June7 - thanks for that. I went down the "change from a calculated field" and I now have the concatenated field by a different route. And it works. Thanks. Leon