I work with MS Access 2003.
I have a query with parameter to show all contracts in place of a single year, specified by the parameter. The name of this column with the years, I called "Contract Year".
I wish to add a criteria that then shows cancelled contracts at the end of that specific year.
I tried the following as criteria for the Column "Cancelled":
To try and have it take the year mentioned in that field.
But it doesn't work. I tried adding LIKE to it and the &-sign, still no luck.
Is it possible to use a filed name in a date criteria and if so, how could I do it?
I am not yet familiar with VBA or macro's, though I'm eager to learn about this.
Thank you very much in advance for your help.