combining two queries

[camell]

alright i can admit it, I'm not that good at this. I'm trying to make a report that will in the end show how many cabs a company has, how many cabs have not been inspected and the percentage of their fleet done or not done. I have made separate queries showing the total cabs by Co. and one showing totals of cabs not inspected. I can not make one query showing both of the totals correctly together. any help would be great

[pbaldy]

Are you a competitor of ours or a regulator? I need to know whether to be nice or not.

If the inspection field is Null when there's no inspection, this should work:

SELECT Count(*) AS CountOfCars, Count(InspectionField) AS Inspections, Format(Count(InspectionField)/Count(*), "Percent") as PercentageDone
FROM TableName

[camell]

Are you a competitor of ours or a regulator? I need to know whether to be nice or not.

which one are you going to be nice too?

if I understand it right, it looks like you are pulling the info from one table.
i have a table for vehicle inventory and a table for VDR issused which has a field for inspection among others and yes not inspected is null

[pbaldy]

I was only kidding; I'm nice to everybody. It should still be doable, but with a join on the two tables. Can you post a sample db we can play with?

[camell]

I was able to finally show both cabs in service and not inspected on the same list with out the extra info, by adding the join now all i have to do is figure out the percentage column.

SELECT [4) Cabs in service totals].lkpCabCo AS [Cab Co], [4) Cabs in service totals].CountOfstrVIN AS [Cabs in service], [4) cabs not inspected totals].CountOfstrCabNumber AS [Cabs not inspected]
FROM [4) Cabs in service totals] INNER JOIN [4) cabs not inspected totals] ON [4) Cabs in service totals].lkpCabCo = [4) cabs not inspected totals].lkpCabCo;


it aint pretty right now but it works so far