Search results

GinaWhipp - thanks. I've tried using a 2nd query to find the max, but changing the Total option to Max changes nothing in the query. It still returns every entry even when multiple entries have the same reference number. gblack - thanks. I'll try and explain it better. Each case has a unique...

Hi. I've got fairly simple knowledge when it comes to Access so please go easy on me. I'm currently :banghead: trying to get this to work. I have a form where the user enteres details about a customer's case. Within that form is a subform for the user to enter the date of every letter received...