Skip to Content
0
Former Member
Dec 03, 2008 at 04:12 PM

Combine Unlinked Data

21 Views

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!