Solved Criteria - Referencing Another Field

[monkeyman77]

Hello, I am trying to create a query that shows that last time a vehicle was serviced but for multiple services.

So the end view would be a matrix that would look like:
Row - Equipment Number
Column - Service Type
Middle - Dates indicating the last time a piece of equipment was serviced for the column indicated service

The attached pictures show what I've been trying to do in the query but I'm not sure I can even do what I am trying.

Please HELP!!!!!

 

[monkeyman77]

Maybe this is something i need to figure out how to do in a form not the query. Your example of does provide me with all the information i need. However, i need the end sure to be able to see the data differently.

Attached is the view i am trying to show the end user

 

[monkeyman77]

Awesome! Thank you!