Maths on a Form - Date Math in Microsoft Access


	Back to Date Math Comments List

Maths on a Form Upload Images Link Email

Gary Simpson

8 months ago

Hi Richard MPV, Rost. I have a database For (Vehicle) With 3 Rows
Row1 = VehicleID
Row2 = MOTDateFrom
Row3 = MOTDateTo
Now when I Type or select a date in Row2. is It possible to Update Row3 Automatically to add one year. I have tried to use the (DateAdd Function) to no avail, In the query the function works well. But how do I get the value into the forms textbox (MOTDateTo)

Kind Regards Gary

	Juan C Rivera 8 months ago
DateAdd This video has the answers V/r Juan

	Gary Simpson 8 months ago
Hi Juan C Rivera. Thank you for getting back to me. Yes this Video explained how it works in the query. But How do I get the result of the query into my textbox on my form. Regards Gary

	Juan C Rivera 8 months ago
I recomend 2 videos Bang! v Dot. and Value From a Form If after the 2 videos you are having a problem come back and lets walk you through it. I know once you get this your going to say wow way to easy but by just looking at it can be confusing. V/r Juan

	Gary Simpson 8 months ago
Hi Juan, Thank you for getting back to me. I have now watched Bang! V Dot And the Value From a Form. I believe I understand the concept Now. Juan Can you tell me if there is a date Format DDD, DD/MM/YYYY. ? ( Mon, 01 / 01 / 2024 ). To fit all in one textbox Kind Regards Gary

	Juan C Rivera 8 months ago
Format([YourCriteria],"DDD" & " " & "DD/MM/YYYY") add your field in the yourcriteria and the output should be what your looking for. V/r Juan

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Date Math.