Solved

My Access Join Query is Not Returning Anything?

Posted on 2011-09-09
2
229 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 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
Comment Utility
you need to include the possible_week_ending_dates table in your select clause.
0
 

Author Closing Comment

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
mySql Syntax 7 20
Export code - file path based on either at Home or Work 5 21
Splitting out Data 14 27
Search field on a form 7 12
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

762 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

12 Experts available now in Live!

Get 1:1 Help Now