cycle# is ascending numeric in the battery table. when adding a flight I need the cycle # in flight to lookup the cycle# in battery add one to it store than in battery and enter it in flight cycle field.
Sorry I am very good at Clarion programming but very new to Access and don't understand your answer.
Quote:
|
Originally Posted by healdem
is your cycle number ascending numeric
..if so select my,column,list, max(cycleno) from mytable where aircraftid=blah
is your battery usage time satmped
...if so select top(1) batteryuse from mytable
|