Hi All,
I have a form and I am trying to highlight all values that equal the top value. I recently learnt that I can create a query style record in this thread and thought I can apply the same principals.
https://access-programmers.co.uk/forums/showthread.php?t=291097
So in the conditional formatting wizard I created;
[qryEmployee].[Field1]=(SELECT TOP 1 Dupe.Field1 FROM qryEmployee AS Dupe WHERE qryEmployee.EmployeeID=Dupe.[EmployeeID] ORDER BY qryEmployee.DateAndTime DESC)
This uses the expression but I have tried Field Value Is (SELECT Top 1 .......)
qryEmployee groups all the data from tables required in the form.
The conditional formatting doesn't work but I have created a query (and removed the Dupe reference and filter the EmployeeID manually) where it shows the matching field I want it to. Is there an easier way to highlight a textbox if it matches the most top value in the form?
Thanks
I have a form and I am trying to highlight all values that equal the top value. I recently learnt that I can create a query style record in this thread and thought I can apply the same principals.
https://access-programmers.co.uk/forums/showthread.php?t=291097
So in the conditional formatting wizard I created;
[qryEmployee].[Field1]=(SELECT TOP 1 Dupe.Field1 FROM qryEmployee AS Dupe WHERE qryEmployee.EmployeeID=Dupe.[EmployeeID] ORDER BY qryEmployee.DateAndTime DESC)
This uses the expression but I have tried Field Value Is (SELECT Top 1 .......)
qryEmployee groups all the data from tables required in the form.
The conditional formatting doesn't work but I have created a query (and removed the Dupe reference and filter the EmployeeID manually) where it shows the matching field I want it to. Is there an easier way to highlight a textbox if it matches the most top value in the form?
Thanks