Recent content by maddak

Hi CJ, Thank You a lot for your help, the DMax you provided did work, I've tried something similar earlier but clearly did it wrong. BTW, if not too much to ask, how does aliasing the table help in this particular situation? Also thanks for pointing out the unecessary double subquery...

I've tried the IIF eventually getting to this form: where various code means: (SELECT Max(DataTable.ResultsYear) FROM DataTable WHERE (((DataTable.Region)=[Forms]![Form1]![cmbRegion]))) or Max (access doesn't allow it) or DMax("ResultsYear","DataTable","Region"= &...

Hello, I'm trying to run a query which fetches only the last 2 years of data for a given region from a table with several years worth of data (there are year, region, sector and rank columns among others). The region is passed into the query from a combobox from Form1. The first problem was...