Hello Everyone,
I am fairly new to this forum and also Access database, so this question might seem really lame, but I really need some help here.
Following is an example of table I am working with.
ID Device Number 1st Cal Date 1st Due date 2nd Cal Date 2nd Due date Next Due Date after today 1 1234 03/31/15 03/31/16 02/03/16 02/03/17 2 4567 04/14/15 04/14/16 01/26/16 01/26/17 3 7890 03/08/16 03/08/17
I am trying to fill the column such that the next due date after "Today" within that row is displayed.
For example in the first row it should be 02/03/17 and so on for the next rows.
In excel the formula I use is (MIN(IF(ROW2Col3:Row2Col6)>Today()),Row2Col3:Row2C ol6)
Pretty straight forward, but with access I am not entirely sure how to do the same.
So far I have tried using the Calculated field using Date/Time, but I get an #ERROR.
any help will be greatly appreciated.
Thank You