John Vinson said:
Is this a calculated column, or is it stored in the table somewhere?
I calculate the quarter's miles on the report, actually. My query just
spits out the current and previous quarters' mileages.
Could
you open one of your queries in SQL view and post it here, so I have a
clearer handle on how your tables and queries are structured?
Here's my 2nd/3rd quarter query. It's the one that works like I want all
the quarters to.
SELECT tblVehInfo.Vehicle, tblVehInfo.Location, tblVehInfo.Color,
tblVehInfo.Style, tblVehInfo.Year, tblVehInfo.[Purchase Date],
tblVehInfo.[Beginning Mileage], tblVehInfo.[Gross Purchase Amount],
tblQuarterly.Date, DatePart("q",[Date]) AS Expr1, tblQuarterly.[Current
Mileage], tblQuarterly.[Current Value], crsMileageLastQ.[Qtr 1],
crsMileageLastQ.[Qtr 2], crsMileageLastQ.[Qtr 3], crsMileageLastQ.[Qtr 4],
crsQuarterlyRep.[Qtr 1], crsQuarterlyRep.[Qtr 2], crsQuarterlyRep.[Qtr 3],
crsQuarterlyRep.[Qtr 4], crsYeartoDate.[Total Of Cost of Repair]
FROM (((tblQuarterly INNER JOIN tblVehInfo ON tblQuarterly.Vehicle =
tblVehInfo.Vehicle) INNER JOIN crsMileageLastQ ON tblVehInfo.Vehicle =
crsMileageLastQ.Vehicle) INNER JOIN crsYeartoDate ON tblVehInfo.Vehicle =
crsYeartoDate.Vehicle) INNER JOIN crsQuarterlyRep ON tblVehInfo.Vehicle =
crsQuarterlyRep.Vehicle
WHERE (((DatePart("q",[Date]))=DatePart("q",Date()-90)));
Hope this helps.
Melinda