MS access query error :Syntax error(missing operator)

Question

I am trying to run a query on MS Access I am a newbie in it. I have to find difference of two dates then find count of those who have diff > 10.I am using the datediff

Function for the same

SELECT  count(Admission No.)
From Admissions
where DATEDIFF(DAY, Admission Date, Discharge Date) >10

Where i am going wronmg i am getting a syntax error

Robert · Accepted Answer · 2013-07-25 07:28:22Z

1

Try to encapsulate fields name in square brackets

SELECT  count([Admission No.])
 From Admissions
 where DATEDIFF(DAY, [Admission Date], [Discharge Date]) >10

answered Jul 25, 2013 at 7:28

Robert

25.8k8 gold badges70 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MS access query error :Syntax error(missing operator)

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related