J
Jamie P via AccessMonster.com
I am having trouble generating a query that will only give the most recent
vehical mileage (vin number) that was recorded on the [tblMileage]. I need
to use that mileage in several other areas. I need alot of help for this one
I have been fighting with this for awhile. Please help..... I enclosed a
copy of the SQL of the query.
SELECT DISTINCTROW First([qryMileage Query].[Date By Month]) AS [FirstOfDate
By Month], [qryMileage Query].[Vin Number], [qryMileage Query].[Sum Of
Mileage]
FROM [qryMileage Query]
GROUP BY [qryMileage Query].[Vin Number], [qryMileage Query].[Sum Of Mileage],
Year([qryMileage Query].[Current Month])*12+DatePart('m',[qryMileage Query].
[Current Month])-1;
vehical mileage (vin number) that was recorded on the [tblMileage]. I need
to use that mileage in several other areas. I need alot of help for this one
I have been fighting with this for awhile. Please help..... I enclosed a
copy of the SQL of the query.
SELECT DISTINCTROW First([qryMileage Query].[Date By Month]) AS [FirstOfDate
By Month], [qryMileage Query].[Vin Number], [qryMileage Query].[Sum Of
Mileage]
FROM [qryMileage Query]
GROUP BY [qryMileage Query].[Vin Number], [qryMileage Query].[Sum Of Mileage],
Year([qryMileage Query].[Current Month])*12+DatePart('m',[qryMileage Query].
[Current Month])-1;