Novice
Windows 11 
Office 365
Hi,
I have a huge query with numerous expressions. I get that message but can't find the culpret. Is there any way to search for the field, either in the SQL or the query grid? The specified field <field> could refer to more than one table listed in the FROM clause of your SQL statement. (Error 3079)
Excess Access
Windows 11 Access 2021
Sure. You have the same field name(s) in more than one table. The error is asking you to specify (in the criteria) which table that field is in.
Right now you have fieldname
You need
tablename.fieldname
Novice
Windows 11 Office 365
Yes, I understand but I can't find it. I was asking if there is some way to search this page full of sql to locate the offensice field.
VIP
Windows 11 Access 2021
Yes, in SQLView go to Home tab and click the Find icon (magnifying glass).
Or copy/paste to a text editor like Notepad and search there.
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.
VIP
Windows 11 Access 2019
I just use Ctrl+F. Standard Windows find command?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
The specified field '[Period to Post]' could refer to more than one table...
Posting Permissions
Reply With Quote