MS Acess SQL - where clause to get year from date based on the year - data located in MS access form
- by primus285
OK, back again. I have a problem getting a drop down list to populate based on information in two fields.
I have got the SQL correct as to Select just one year if I put DateValue('01/01/2001') in both places, but I am trying now to get it to grab the year data from the MS access form - another drop down named "cboYear".
I'd hate to have to do…