I'm quite comfortable working with Access and VBA but one brief field in a query is confusing a little.
Any help would be appreciated:
I have form of frmReports
On this form is a combo drop down for years called cmbYears
The source table has a field of the date.
I want to return rows where the year is either greater than the cmbYears choice or, if the cmbYears is blank then return all rows
So far I have used:
where the criteria is below the field:
As I see it, this is the bit that isn't working as I had anticipated: