G
Guest
wonder if anyone can help me - i have a sub-form which lists all details of
licences held by various customers - each licence has an identifying number
which it keeps throughout the life of the licence, however these licences are
renewed every 3 years and can be amended at any time. As a result i can have
a number of records with the same licence number although the status may vary
- the current version will be the most up-to-date one. How can i sort my
data so that when the form is opened the most recent licence is the first
transaction displayed on the sub-form - i would like to do this by using the
input date which operators enter at the time of issue/amending. The only way
i can think of is to base my sub-form on a query and use the ascending sort
in the input date field - is there any other way which i can use on the
existing subform?
licences held by various customers - each licence has an identifying number
which it keeps throughout the life of the licence, however these licences are
renewed every 3 years and can be amended at any time. As a result i can have
a number of records with the same licence number although the status may vary
- the current version will be the most up-to-date one. How can i sort my
data so that when the form is opened the most recent licence is the first
transaction displayed on the sub-form - i would like to do this by using the
input date which operators enter at the time of issue/amending. The only way
i can think of is to base my sub-form on a query and use the ascending sort
in the input date field - is there any other way which i can use on the
existing subform?