Recent content by Bigfella928

Hi All. Pat Hartman's solution worked great thanks. Thanks so much for the help all.

Hi plog. I have an expiry date. I am thinking I have to find the last entry for each person by card type which will get rid of previous similar cards. Then do a <date() on the remaining. Just not sure how to do the first bit. Cheers

hi the DBguy. Thanks for the welcome. Pretty sure I will need to but have tried numerous ways without success so far.

Hi, All. Could use some help here please. Complete novice at SQL or Access for that matter I have a table of records that stores training card information including date date added, expiry date, employee name, card type, Card Serial No. Each employee could have multiple cards of the same type...