Write expression in Access Database
Budget: $10 – $30 AUD
Require to develop the calculated field in Access DB. So when new data is imported, the expression builder will calculate the HorseStartTime
Calculating Horse Start Time
To calculate each horse’s start times, obtain times in DB,
A) If RaceDistance 930M to 1099
Horse_FinishTime [minus] Horse_L800 = Horse StartTime
B) if RaceDistance 1100M to 1299
Horse_FinishTime [minus] Horse_L1000 = Horse StartTime
C) If RaceDistance 1300M to 3200
Horse_FinishTime [minus] Horse_L1200 = Horse StartTime
Calculating Horse Start Time
To calculate each horse’s start times, obtain times in DB,
A) If RaceDistance 930M to 1099
Horse_FinishTime [minus] Horse_L800 = Horse StartTime
B) if RaceDistance 1100M to 1299
Horse_FinishTime [minus] Horse_L1000 = Horse StartTime
C) If RaceDistance 1300M to 3200
Horse_FinishTime [minus] Horse_L1200 = Horse StartTime