How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 37544
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I have created a data base in Microsoft Access 2007. I am trying

Customer Question

I have created a data base in Microsoft Access 2007. I am trying to pull some information from one of my tabs and I get the message "The specified 'Title' could refer to more than one table listed in the FROM clause of your SQL statement". What does this mean and how do I fix the problem?
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Richard replied 4 years ago.

RichieMe :

Thank you for your question, my name is Richard.

It means that you are referencing a field that has the same names in two tables.

So for instance,

select orders from order, otherorders

Orders is in both so it will error. You need to do it as

select order.orders from order, otherorders.

This means you specify in your query exactly where it comes from.

If you have any difficulties at all, please do not hesitate to let me know so I can assist you further

Thank you