Filter the data displayed on a from. 1

[sheusz]

Hello All,

Since joining this forum I've learnt a lot about MS Access and every question that I have asked has given me a solution. I am hoping that someone can help me with this little problem.

I have a form that displays on it the last time I visited a customer;

=DMax("[Service Date]","xServices","CustomerID='" & [CustomerID] & "'")

This works great, but what I also want to do is have the form display on it the last time I visited the customer to perform a routine service. Like this;

Last Visit: 10/01/08
Last Service: 30/11/07

The last visit my not have been for a routine service

The table xServices has a text data field called Catagory.

The Catagory field has the following Data Row Source;
"S Call";"Service";"Training";"Repairs";"Commissioning"

What code do I need in order to get it to display the last service date on the form?

Thanks in advance for your help.

 

[PHV]

Something like this ?

=DMax("[Service Date]","xServices","CustomerID='" & [CustomerID] & "' AND Catagory='Service'")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sheusz]

Yeah! Just like that. Many thanks to you PH.