wavemehello
Board Regular
- Joined
- Jan 24, 2006
- Messages
- 221
-I have a query in design view
-right click, build, expression and this is what i typed
SELECT * FROM table1
WHERE month(dob)=month(date)+1
It seems incorrect.
(I am trying to query the records whose DOB field has month equal to coming month of system date)
Can someone assist me with the code?
-right click, build, expression and this is what i typed
SELECT * FROM table1
WHERE month(dob)=month(date)+1
It seems incorrect.
(I am trying to query the records whose DOB field has month equal to coming month of system date)
Can someone assist me with the code?