Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Access 2010 Query

Posted on 2015-01-29
3
Medium Priority
?
131 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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

783 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