B
Brien Clark
I'm trying to create a query that has all unique values. I am working with
two tables: IDFeatures and Readings.
The IDFeatures table contains all the IDfeatures (a unique number given to
each object) as well as some static information pertaining to each IDfeature.
In this table, there are no duplicate IDfeatures.
The Readings table has readings and dates for each IDfeature. There are
multiple readings/dates for many of the IDfeatures, so there are duplicate
IDfeatures (with different readings/dates).
The tables are set up with a relationship so that the IDfeature is correlated.
Right now, I can only create a query that displays all the readings (with a
duplicate IDfeature for each different reading). I am trying to create a
query that displays only one IDfeature with the most current readings from
the Readings table. Using the DISTINCT command does not work, since the
Readings table has non-duplicate columns (i.e. different readings dates).
Someone suggested using a MAX command, but I don't know if that actually
exists (I couldn't find it in the help file or Balter's Mastering Access).
Does anyone have any ideas? Thank you
two tables: IDFeatures and Readings.
The IDFeatures table contains all the IDfeatures (a unique number given to
each object) as well as some static information pertaining to each IDfeature.
In this table, there are no duplicate IDfeatures.
The Readings table has readings and dates for each IDfeature. There are
multiple readings/dates for many of the IDfeatures, so there are duplicate
IDfeatures (with different readings/dates).
The tables are set up with a relationship so that the IDfeature is correlated.
Right now, I can only create a query that displays all the readings (with a
duplicate IDfeature for each different reading). I am trying to create a
query that displays only one IDfeature with the most current readings from
the Readings table. Using the DISTINCT command does not work, since the
Readings table has non-duplicate columns (i.e. different readings dates).
Someone suggested using a MAX command, but I don't know if that actually
exists (I couldn't find it in the help file or Balter's Mastering Access).
Does anyone have any ideas? Thank you