I am getting synatx error in the following expression:
Dsum(“[Dep]”,”[InterestTable]”,”[Tdate]>=#01/04/2021# and <=#31/03/2022#”)
Please Help
I am getting synatx error in the following expression:
Dsum(“[Dep]”,”[InterestTable]”,”[Tdate]>=#01/04/2021# and <=#31/03/2022#”)
Please Help
You have to repeat the field name:
Dsum(“[Dep]”,”[InterestTable]”,”[Tdate]>=#01/04/2021# and [Tdate] <=#31/03/2022#”)
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Tried Dsum(“[Dep]”,”[InterestTable]”,”[Tdate]>=#01/04/2021# and [Tdate] <=#31/03/2022#”) but getting syntax error.
Date format in the table is dd/mm/yyyy