New to creator and just starting on my 1st project. Have some self taught experience of access and SQL but this is a long time ago.

Am working on an asset tracker for use by us as an OEM and our customer as they use and distribute our machines. Mostly I need to track current location and current condition.

I have a base form for my machine data such as serial number and then some other forms for input of location change and condition change.

As the machines are used they will move around to lots of different locations and will have many different conditions (OK, repair req, scrap etc) in their life.

I need to bring a view together that shows the current/latest location and condition of each machine.

If I have a form that has several dated location changes how do I create a view that sorts these by serial number and date to just show me a single record for each serial number with its latest location.

In access I would have used a "crosstab" query to sum the data.

Sorry if this is a simple question that I should be able to do,

Regards