So I'm having a little fun while I brush off the cobwebs from my access knowledge, I wasn't an expert by any means but I knew enough to create basic databases. Anyway, I decided to set up a database for my favourite interest, wrestling, just because I love it a little too much!! :p
Anyway, I have all my tables set up and I decided in the forms for the wrestlers (when I've set them up) I want to have the dates, venues etc. of the following:
Most Recent Appearance
Most Recent Match
Most Recent Win
Most Recent Loss
Should these be done via queries and if so would someone mind talking me through how to get them set up.
Thanks in advance
Nikki
Anyway, I have all my tables set up and I decided in the forms for the wrestlers (when I've set them up) I want to have the dates, venues etc. of the following:
Most Recent Appearance
Most Recent Match
Most Recent Win
Most Recent Loss
Should these be done via queries and if so would someone mind talking me through how to get them set up.
Thanks in advance
Nikki
I pretty sure this should be a query... can anyone confirm
