Search results

Ok.. its been a while since i last used VB in Access and i got a bit rusty, and tbh i remember nothing :P Am trying to figure out a script to use in a field ( Due Return Date ), that will take a Date value from a specific field (Date Loaned) and will add 2 to the date. E.g Date Loaned...

Hello, am trying to make a code, that will set a value in the specific field only if the current value is more than 0, but i cant get it to work... here's the code: If Me![DaysLoaned] <= 0 Then Me![DaysLoaned] = Int(DateDiff("d", Me![DueReturnDate], Date)) Else Me![DaysLoaned] = "Doesnt Apply"...