Good morning,
I think this is a simple one, but it is a bit early for me this morning.
I am trying to add a userform to an Access database table which I have, but how do I add a if query to give me an outcome to add in in.
I need to be able to submit an answer based on if the dates are higher/lower as per below.
All help appreciated
thanks
I think this is a simple one, but it is a bit early for me this morning.
I am trying to add a userform to an Access database table which I have, but how do I add a if query to give me an outcome to add in in.
I need to be able to submit an answer based on if the dates are higher/lower as per below.
Code:
.Fields("Worked By") = Worksheets("Calcs").Range("B7").Value
.Fields ("When Keyed") = (DTPicker1 = DTPicker2,"Same Day Booking",if(DTPicker1 < DTPicker2,"In Advance","After Booking")
All help appreciated
thanks