Hi all,
I am having difficulty writing an If & And statement
I am building a DB using Microsoft Access. What I want to do is write an if statement that will tell the user that a video has not been returned by the customer that is currently trying to rent another video.
My entities are:
[Return Date] Date field
[Returned] Yes/No check box
What I was thinking of was using the Date() function where if [Return Date] <= Todays Date And [Returned] = false then a message box would appear MsgBox "A movie has not been returned"
Hope someone can help.
Many thanks in advance
I am having difficulty writing an If & And statement
I am building a DB using Microsoft Access. What I want to do is write an if statement that will tell the user that a video has not been returned by the customer that is currently trying to rent another video.
My entities are:
[Return Date] Date field
[Returned] Yes/No check box
What I was thinking of was using the Date() function where if [Return Date] <= Todays Date And [Returned] = false then a message box would appear MsgBox "A movie has not been returned"
Hope someone can help.
Many thanks in advance