I have an appointments table & a meetings table that are NOT dependent on each other. Both tables contain a StartDate field which is a common field but not a unique identifier in either table. In my report, I would like to group by day & show all appointments & meetings on each day. I also need a combined count of meetings + appointments for each day. How can I accomplish this? I have tried joining on the StartDate field & changing the join types but cannot get the result that I want.
Thanks in advance!