Please be more specific. See Rule #2.
Please send screenshots of the tables involved in Design View.

DMax

Aggregate Query

Probably something like:

Sys = DMax("Systolic","BloodPressureT")

Then you can look up the date with DLookup:

D = DLookup("MyDate","BloodPressureT","Systolic=" & Sys)

I've got a similar TechHelp video coming out soon. Another student asked how to find the date of their highest sale amount. Same principle.

Thank you all, i greatly appreciate your help

Thanks for the DMax code it works perfectly on the entire database however i need to use a query with between dates to obtain the highest pressure in a date range. When i change the table name in the string to the query name, i get errors. Any suggestions would be appreciated. Thanks

Sys: DMax("Diastolic","BPQ")
D: DLookUp("PatDate","BPQ","Diastolic=" & [Sys])

What's the error?

Do you have parameters in that query? Try to D-Function directly from a table if possible. It will run faster too.

Attached is the query and the results. I am trying to result the highest BP and Date it was taking for the period in the date criteria. The results are incorrect even if i specify the date range i am still getting the results from the entire table. If reconfigure the query using a query in place of the table, i get syntax errors.

Put the value you want the maximum o in the first column and use DMax for your criteria. Then you can use DLookup in the second column to look up the date. See screenshot below.

Note: this is something I would usually do with a couple of Form fields. Then you wouldn't need the query at all.

I tried to do that on the form in a text field and have done that before but i just couldn't get it configured.