Query with Dates

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.

Featured Post

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…

In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …

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…