CODEWITHSUNDEEP
vbams-access
Ethan
Ethan

Reputation: 51

Need Some MS Access Guideance

SELECT ID, OurMaps FROM tblMatterList where Matter_OpenDate=true and datestarted between dateadd("d", ([period]-1)*14,datevalue("01/01/" & year(date())) and dateadd("d", (([period]-1)*14)+14,datevalue("01/01/" & year(date()))

Does anyone know why this code isn't working, I keep getting a Compile Error: Expected: Case

Many Thanks

Upvotes: 0

Views: 68

Answers (1)

Matt
Matt

Reputation: 13399

You're missing a bracket from each of the dateadd functions, add one closing bracket after each:

year(date()))   <-- add another close bracket here

Upvotes: 1

Related Questions