I am new to SQL so forgive me if this is an SQL 101 question. I have 2 tables relating to vehicle use by employees. I am creating a report to give me totals on number of vehicles, total stops, total miles, total hours and averages stops per mile and stops per hour. The code works for everything but the averages. I get zero in the output field. I've tried lots of different things, all resulting in same output.
Results:
Car...