P
Philip Martin
Using Access 2000.
I have a table, Plant Inspection Table. Amongst others this contains the
fields Inspection Date and Plant Name. The table will contain multiple
records of plant inspections and the dates of these, with a total of some 60
individual items of plant. There is also another table that lists the plant
items and their inspection frequency so ultimately I will want to calculate
when an inspection is due, but for now I'm stuck on extracting the last date
each item was inspected.
What I need to do is to create a query that will list each item of plant and
the last date that it was inspected. I've tried with the totalise query with
the Group by of the Inspection Date field set to Max, but of course this
also gives me every occurrence of each item of plant, not just the last one!
Any help in solving the problem and helping me learn a little more would be
welcome
)
TIA,
Philip Martin.
I have a table, Plant Inspection Table. Amongst others this contains the
fields Inspection Date and Plant Name. The table will contain multiple
records of plant inspections and the dates of these, with a total of some 60
individual items of plant. There is also another table that lists the plant
items and their inspection frequency so ultimately I will want to calculate
when an inspection is due, but for now I'm stuck on extracting the last date
each item was inspected.
What I need to do is to create a query that will list each item of plant and
the last date that it was inspected. I've tried with the totalise query with
the Group by of the Inspection Date field set to Max, but of course this
also gives me every occurrence of each item of plant, not just the last one!
Any help in solving the problem and helping me learn a little more would be
welcome
)TIA,
Philip Martin.