I have a relatively simple query containing two linked tables. One containing authorisation number the other containing appointments. I am trying to filter the query to only show records where the Use_By (Date field) in the tbl_Authorisation > AptDate (Date field) in the appointment table.
On the criteria line of the Use_By field I have entered >#[AptDate]# but get a “The expression you have entered has an invalid date value” both the AptDate & AptDate are date type
Any suggestions to what I am doing wrong?