Hi Team, I have a form where I have ComboBox with the list of Years (2018,2019,2020,2021) and I have the proper dates in my Database as shown below:
Whenever I select any year(example: 2020) in the form, the results should populate the Records between 01/01/2020 till 31/12/2020.
I have tried the following code in the query criteria:
"between #01/01/" & [forms]![frm_Search_Projects]![Cmb_Year] & "And #01/01/" & [forms]![frm_Search_Projects]![Cmb_Year]));
I'm getting an error stating that the expression typed incorrectly or it is too complex to be evaluated.
Please help!! Thanks in advance!!
Dates |
---|
04/01/2021 |
03/22/2021 |
07/22/2020 |
08/16/2019 |
Whenever I select any year(example: 2020) in the form, the results should populate the Records between 01/01/2020 till 31/12/2020.
I have tried the following code in the query criteria:
"between #01/01/" & [forms]![frm_Search_Projects]![Cmb_Year] & "And #01/01/" & [forms]![frm_Search_Projects]![Cmb_Year]));
I'm getting an error stating that the expression typed incorrectly or it is too complex to be evaluated.
Please help!! Thanks in advance!!