Filter for last input

[vericlese]

I would like to know if Access can filter a record so that only the last field with input is displayed. Example: I have a record for an individual that has multiple dates in which he was trained on a task. These "dates" are entered into seperate fields on his record for the purpose of showing progression and retraining. Can i filter these fields so that only the last field with an entry is shown? I will be using this to create a report with numerous personnel and do note want to show every date, just the last entry made. These "date" fields are also tied to a "location" field. Can they be shown as well? Any assistance with this would be greatly appreciated.

V

 

[ColinEssex]

The way I read this (I may be wrong) is that you have a field for the first date and another field for the 2nd refresher date and another for the 3rd and so on.
If this is the case you have (in the table) a series of dates going across the screen. You ideally should have one line for each new record.

To get this, you should have one date field and a subform to show the earlier dates. This makes it so much easier to pick up the latest date for any given course or whatever.

You can pick up the latest date by using the DMax function, but not if the dates are horizontally going across the screen.

Col

 

[vericlese]

I agree however, the user requires that all fields are shown while in form view. This was the reasoning for mindlessly splattering all the "date" fields across the bottom of the form but the only want the last entry on their reports. Is there a better way to do this while still meeting the user requirements?

V