2. Next, if Animal has lost over 15% of weight since last weighed
tblAnimal
AnimalID PK
Animal (Text)
tblWeight
WeightID PK
AnimalID FK
aWeight (Text) Weight of Animal.
DateWeighed (Date Weighed)
Code: Select all
SELECT DISTINCTROW qryAnimals.AnimalID, qryAnimals.Animal, qryAnimals.aWeight, qryAnimals.DateWeighed, DateDiff("d",[DateWeighed],Date()) AS ByDate
FROM qryAnimals
GROUP BY qryAnimals.AnimalID, qryAnimals.Animal, qryAnimals.aWeight, qryAnimals.DateWeighed, DateDiff("d",[DateWeighed],Date())
ORDER BY qryAnimals.Animal;