?
Solved

My Access Join Query is Not Returning Anything?

Posted on 2011-09-09
2
Medium Priority
?
275 Views
Last Modified: 2012-05-12
I have a need for a continuous time line report. That is, there must be an entry for every week, even if that entry is zero events.

To accompllish that, I am trying to Make a Right Join Query of  a table with the data I need and the week it occurred, with a Table of the Possible Week ending dates.

When I run the query, however, it returns nothing. I used the Access Query designer to create the relationship and the query. I have pasted the SQL below.
SELECT QPR_Interstuhl_QNs_tbl.[WeekEndingDate], QPR_Interstuhl_QNs_tbl.[Total_QNs]
FROM QPR_Interstuhl_QNs_tbl RIGHT JOIN Possible_Week_Ending_Dates_Tbl ON QPR_Interstuhl_QNs_tbl.WeekEndingDate = Possible_Week_Ending_Dates_Tbl.PossibleWeekEndingDates;

Open in new window

0
Comment
Question by:Rex85
2 Comments
 
LVL 50

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 36512929
you need to include the possible_week_ending_dates table in your select clause.
0
 

Author Closing Comment

by:Rex85
ID: 36512982
Well! That was easy. (After you showed me!) Thanks.
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
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…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

569 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