hello guys im making a database on ms access for a DVD rental store.
I have 2 problems which i cant overcome please help me
my first problem is creating validation rules for my date/time field which will work on my form. So i want the computer to warn the user to input in dd/mm/yyyy format. How can i do this????
Secondly, i have a querry which searches overdue DVDs. Although it works with no problems, i want the search to not show the DVDs which are returned that can be seen on the form as a box which i can mark ( a Yes/No field).