Hello All;

Listed below are 2 independant queries that each run fine and return complete and proper data. I copied and pasted the SQL from each individual query to make the Union query. The union query does not return complete proper data. The union query has blank rows of reason codes. The union query returns the ReasonCode ID, not the description on SOME of the dispute reasons. The data problems seem to be related to the tbl_DisputeCases table data. Can anyone spot what might be the problem with what I have included?

Thanks...
Larry

SELECT [tbl_DisputeCases].[InitiationDate] AS [Date#], [tbl_DisputeCases].[ReasonCode] AS [Type#], Count([tbl_DisputeCases].[ReasonCode]) AS [ReasonCodeCount#]
FROM tbl_DisputeCases
GROUP BY [tbl_DisputeCases].[InitiationDate], [tbl_DisputeCases].[ReasonCode]
HAVING ((([tbl_DisputeCases].[InitiationDate]) Between [Forms]![frm_ManagementReportsMenu].[StartDate] And [Forms]![frm_ManagementReportsMenu].[EndDate]))
ORDER BY [tbl_DisputeCases].[ReasonCode];

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++

SELECT [tbl_MiscMail_OneDayBENsCases].[DateOfInitiation] AS [CaseDate#], [tbl_MiscMail_OneDayBENsCases].[TypeOfInquiry] AS [ReasonCode#], Count([tbl_MiscMail_OneDayBENsCases].[TypeOfInquiry]) AS [RCcount#]
FROM tbl_MiscMail_OneDayBENsCases
GROUP BY [tbl_MiscMail_OneDayBENsCases].[DateOfInitiation], [tbl_MiscMail_OneDayBENsCases].[TypeOfInquiry]
HAVING ((([tbl_MiscMail_OneDayBENsCases].[DateOfInitiation]) Between [Forms]![frm_ManagementReportsMenu].[StartDate] And [Forms]![frm_ManagementReportsMenu].[EndDate]));

++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++




SELECT tbl_DisputeCases.InitiationDate AS [Date#],
tbl_DisputeCases.ReasonCode AS [Type#],
Count(tbl_DisputeCases.ReasonCode) AS [ReasonCodeCount#]
FROM tbl_DisputeCases
GROUP BY tbl_DisputeCases.InitiationDate, tbl_DisputeCases.ReasonCode
HAVING (((tbl_DisputeCases.InitiationDate) Between [Forms]![frm_ManagementReportsMenu].[StartDate] And [Forms]![frm_ManagementReportsMenu].[EndDate]))
UNION SELECT tbl_MiscMail_OneDayBENsCases.DateOfInitiation AS [Date#],
tbl_MiscMail_OneDayBENsCases.TypeOfInquiry AS [Type#],
Count(tbl_MiscMail_OneDayBENsCases.TypeOfInquiry) AS [ReasonCodeCount#]
FROM tbl_MiscMail_OneDayBENsCases
GROUP BY tbl_MiscMail_OneDayBENsCases.DateOfInitiation, tbl_MiscMail_OneDayBENsCases.TypeOfInquiry
HAVING (((tbl_MiscMail_OneDayBENsCases.DateOfInitiation) Between [Forms]![frm_ManagementReportsMenu].[StartDate] And [Forms]![frm_ManagementReportsMenu].[EndDate]))
ORDER BY [Type#];