Solved

MS Access 2010 Query

Posted on 2015-01-29
3
109 Views
Last Modified: 2015-01-30
I have a basic query below in Microsoft Access 2010. I am getting an error on the FROM clause.     Thanks for any info.
Select * From Customer
JOIN Address ON Customer.CustomerID=Address.CustomerID
WHERE Address.ZipCode ='12345'
0
Comment
Question by:fjkaykr11
  • 2
3 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 40578675
try this

Select * From Customer
INNER JOIN Address ON Customer.CustomerID=Address.CustomerID
 WHERE Address.ZipCode ='12345'
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 40578707
thanks.  I will have to get back to you tomorrow to see if it worked (I am sure it will)
0
 
LVL 3

Author Closing Comment

by:fjkaykr11
ID: 40581049
it works, thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now