Report based on a query

[lauritz]

Hi,

I need some urgent help. I am new to the Access VBA and have a problem that is causing me lots of grief.

I have a table which contains component data about an engine. Each component has "time remaining" and a "cycle ramaining" field. I need to scan through this table and for each engine display the component with the lowest "time remaining" and lowest "cycle remaining" (most likely the same component). I just cannot for the life of me work out how to do it in the VBA.

All help is greatly appreciated.

TIA

 

[KenReay]

Hi Have you thought about using a Query?

In the query designed see Group by (the E symbol in tool bars), and see Min function

Regards

Ken Reay

 

[lauritz]

Hi Ken,

Yes I have thought about using a query but am not sure how to do what I need to using one. Any ideas?