SELECT [Crisis Calls Attended].[Log No:], [Crisis Calls Attended].[Client Name:], [Crisis Calls Attended].[Client Address:]
FROM [Crisis Calls Attended]
UNION ALL
SELECT[Crisis Calls Attended].[1) Date:], [Crisis Calls Attended].[1) Hrs:], [Crisis Calls Attended].[1) Min:]
FROM [Crisis Calls Attended]
WHERE ((([Crisis Calls Attended].[1) Date:]) Between [Forms]![Date Range].[StartDate] And [Forms]![Date Range].[EndDate]))
UNION ALL
SELECT[Crisis Calls Attended].[2) Date:], [Crisis Calls Attended].[2) Hrs:], [Crisis Calls Attended].[2) Min:]
FROM [Crisis Calls Attended]
WHERE ((([Crisis Calls Attended].[2) Date:]) Between [Forms]![Date Range].[StartDate] And [Forms]![Date Range].[EndDate]));