msoussi Posted March 19, 2015 Share Posted March 19, 2015 I have a database with the folowing fields Start time, End time, Date, and Room. I am triying to creat a field with a validation that will let me know if another record has a room with the same date same strat otime and end time. How do a I do this with validation and choose the calculation option. Thanks Link to comment Share on other sites More sharing options...
comment Posted March 19, 2015 Share Posted March 19, 2015 You cannot validate a Calculation field. However, you can define a Text field and set it to auto-enter a calculated value (replacing existing value) = StartTime & "|" & EndTime & "|" & Date & "|" & Room and validate this field as Unique. Link to comment Share on other sites More sharing options...
msoussi Posted March 19, 2015 Author Share Posted March 19, 2015 thanks for the answer, It worked Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3298 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now