G gear Registered User. Local time Today, 04:14 Joined Mar 10, 2007 Messages 112 Apr 28, 2007 #1 I don't know how to put this question. I have a date field formatted as 'dd-mm-yyyy'. How do I put the code to look up last record's year and if it is previous year's, block additions. Grateful for help.
I don't know how to put this question. I have a date field formatted as 'dd-mm-yyyy'. How do I put the code to look up last record's year and if it is previous year's, block additions. Grateful for help.
E Epic Registered User. Local time Today, 04:14 Joined Dec 23, 2004 Messages 58 Apr 29, 2007 #2 create a query and on group by select max