H
Howelly
Bassically i am making a sunbed program using access. I have a purchases
table, membership table and an appointment table (there are more but
they are not needed for the question).
I have done all the coding in VB through access, and now i am making a
main screen where the user can navigate to each of the forms. On the
main screen i have got a quick view box where the user can enter a
membership no, and a host of information will be shown about that user
in a label on the main screen.
I have obtained a number of infomation, but one of them needed is
their last purchase. The purchase table records the date, but i am
unsure how to obtain the latest date for a certain member, and then
display it in a label.
I have done the bulk of the project in VB code, but any solution as long
as i can understand it, would be greatly appreciated.
Thanks in advance for the help.
Mike Howell
table, membership table and an appointment table (there are more but
they are not needed for the question).
I have done all the coding in VB through access, and now i am making a
main screen where the user can navigate to each of the forms. On the
main screen i have got a quick view box where the user can enter a
membership no, and a host of information will be shown about that user
in a label on the main screen.
I have obtained a number of infomation, but one of them needed is
their last purchase. The purchase table records the date, but i am
unsure how to obtain the latest date for a certain member, and then
display it in a label.
I have done the bulk of the project in VB code, but any solution as long
as i can understand it, would be greatly appreciated.
Thanks in advance for the help.
Mike Howell