Solved

Query with Dates

Posted on 2014-01-17
1
183 Views
Last Modified: 2014-01-17
I am sure this is a stupid question.

I have a table "Memo List Table" and a Querry "qryBookingDayswithYearII"

Both have date columns with a date for every row. My end result is I want a sheet that has all the dates of "Memo List Table" and all the dates from qryBookingDayswithYearII. An then all the corresponding info in for that date. I don't mind if dates are listed twice... one with date for each table/querry.

For some reason, I can't figure out how to do this. Thanks for any help you can provide.

Chris
0
Comment
Question by:cansevin
1 Comment
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 39789617
create a union query


select [dateField], field1,field2 from  [Memo List Table]
union all
select [dateField], field1,field2 from qryBookingDayswithYearII
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

707 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

17 Experts available now in Live!

Get 1:1 Help Now