Expand|Select|Wrap|Line Numbers
- SELECT [Customer List].[Last Name], [Customer List].[First Name], First([Service Records].Date) AS [First Of Date], Sum([Service Records].Price) AS Price
- FROM [Customer List] INNER JOIN [Service Records] ON [Customer List].ID = [Service Records].ID
- GROUP BY [Customer List].[Last Name], [Customer List].[First Name], [Service Records].[Trans #]
- HAVING (((First([Service Records].Date))>=["Start Date" Use format MM/DD/YY] And (First([Service Records].Date))<["End Date" Use format: MM/DD/YY]))
- ORDER BY [Customer List].[Last Name];
Expand|Select|Wrap|Line Numbers
- SELECT [Customer List].[Last Name], [Customer List].[First Name], First([Service Records].Date) AS [First Of Date], Sum([Service Records].Price) AS Price, Sum([Offsite Service Records].Price) AS SumOfPrice
- FROM ([Customer List] INNER JOIN [Service Records] ON [Customer List].ID = [Service Records].ID) INNER JOIN [Offsite Service Records] ON [Customer List].ID = [Offsite Service Records].ID
- GROUP BY [Customer List].[Last Name], [Customer List].[First Name], [Service Records].[Trans #]
- HAVING (((First([Service Records].Date))>=["Start Date" Use format MM/DD/YY] And (First([Service Records].Date))<["End Date" Use format: MM/DD/YY]))
- ORDER BY [Customer List].[Last Name];
Any help would be greatly appreciated.