Hi everyone,
I would like to know how I can give a specific number when I enter a certain data... Let's say I have my first column "Code" where I fill text, a column for the time in takes and a third column "Time expected". When I enter for example the code E in the first column, I want Access to fill "15" in "Time expected". But for some codes, I won't need to fill the column Time expected, it's only for 2 codes (E --> 15 and F --> 30).
Let me show you what I would like to see in datasheet view :
Code Time (mn) Time expected (mn)
A 4
B 7
E 10 15
F 30 30
Thanks !