gj15987

Hi,

This is hard to explain so i'll give all the background information.

I'm making a system that can be used by a reptile shop to keep track of the animals etc. Each animal has a feeding interval which says how many days apart it should have its next meal.

I have a feeding table consisting of Feeding ID, Reptile ID and Date.

I want to have a form that will show all animals that are due a feed.

So I need the feeding table to look up the animal table, find the matching reptile ID, add on the feeding interval for that animal to the date last feeding date and if the date is less than today, then the animal is due a feed.

If anyone could help me in working out how to
1. Find the latest feeding reccord for each animal
2. Add on its feeding interval
3. Calculate whether its due a feed

Any help would be greatly apprechiated.

Thanks
Grant.

gj15987

Sokay! I sussed it thanks! lol