Group 2 date fields

[deiopajw]

I have 2 tables:
Each table has amongst other fields, a respective date field
tbl_A has dateA
tbl_B has dateB

I want to create a query and ultimately throught this query a report showing
a grouping of dates from the two tables;
So the report would show a collection of data from BOTH tables for the day
of 17th Oct for instance and then 18th etc.
Therefore I want to group the data from both tables via date.
I have unsuccessfully tried the report wizard but it will only let you pick
one table date field as a grouping header and not both.
Any suggestions?

 

[Jeff Boyce]

Take a look at the "UNION" query in Access HELP. This will allow you to
create a query that gets records/values from one source (tbl_A) and combine
them with records/values from another (tbl_B).

By the way, if you provide a bit more description (example data) of why you
are storing dates in two different tables, the 'group may be able to offer
design ideas that don't require a UNION query.