Calcualtions Help Needed

[ddrew]

Hi I'm after some help with some calculations please. I have some Fields (SeasonStartDate), (DaysBetweenSeasons), (PredictedSeasonStart).

SeasonStartDate is a Date field and holds the date that a dog goes into season.

DaysBetweenSeasons is a calcuation from the previous records SeasonStartDate to this records SeasonStartDate. so will be a number (days).

PredictedSeasonStart is a date field showing the date that the next season should start, this is a calculated field based on a total of all records (DaysBetweenSeasons) divided by the number of records.

I have no idea how to do the calculations though.

 

[plog]

Can you provide some sample data from your table, then also post what data you expect as a result? Include field and table names. Use this format for posting data:

TableNameHere
Field1Name, Field2Name, Field3Name
James, 13, 2/13/2008
Terry, 22, 4/18/2004
Linda, 4, 12/9/2007