Hi all,
I have created a union query (I have used a union query because my order form has multiple subforms) and I am then trying to use DMax in the order form to show the last modified date and time of the order. As shown in the attached image, I am trying to display the time highlighted in red as it's the most recent time according to the date modified.
I have used the below but all it is doing is displaying the maximum time and doesn't consider the date. So currently the result I am getting is 16:33:08.
How can I get it to work so it shows the maximum time for the maximum date?
Thanks for your help,
Chris
I have created a union query (I have used a union query because my order form has multiple subforms) and I am then trying to use DMax in the order form to show the last modified date and time of the order. As shown in the attached image, I am trying to display the time highlighted in red as it's the most recent time according to the date modified.
I have used the below but all it is doing is displaying the maximum time and doesn't consider the date. So currently the result I am getting is 16:33:08.
Code:
=DMax("Time_Order_Last_Modified","UnionTablesTime","[Order_Number] = '" & [Order_Number] & "' AND DMax(""[Date_Order_Last_Modified]"",""UnionTablesTime"",""Order_Number='" & [Order_Number] & "'"")")
How can I get it to work so it shows the maximum time for the maximum date?
Thanks for your help,
Chris
Attachments
Last edited: