Hello Richard, I'm trying to issue an invoice(report) through my SQL online database, however I get an error message: "Run-time error 3079- The specified OrderT.TLX could refer to more than one table listed in the FROM clause of your SQL statement" Is there the problem that I have to upload the logo' image file on a WWW page? Can you suggest some course where I may find more info about it? Do you think that the cited problem refers to something else? Thank you very much in advance.
Have you added any aliases to your Tables in your FROM clause?
Despina KarayanniOP
@Reply 5 years ago
Oh, I am sorry for bothering the forum, actually this OrderT.TLX was a misused variable that had to be abstracted from the OrderInvoiceQ - the source of the Invoice Report. Thank you very much again.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Server Lessons.