Query with Dates

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.

Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
create a union query

select [dateField], field1,field2 from  [Memo List Table]
union all
select [dateField], field1,field2 from qryBookingDayswithYearII
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.

All Courses

From novice to tech pro — start learning today.