Click here to Skip to main content
15,860,972 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
<The query below appears to not affect the query and still shows all of the data from the DB, but it does not filter the results in the query designer. I need this query to load the datagridview (at from load) with the current Month records. I have the (ThisDate) column set to short date dd/MM/yyyy. Can someone help a novice please, I don’t have much hair left as I’m ripping it out to work this simple query out. HEEEELP i'm struggling!!!!

SELECT tblarp.ID, ThisDate, TimeStart, TimeFinish, TotalTime, StartTempo, FinishTempo, [BPM+/-], Notes
FROM tblarp
WHERE (((Year([ThisDate]))=Year(Now())) AND ((Month([ThisDate]))=Month(Now())));
Posted
Updated 5-Jul-15 1:27am
v3

1 solution

According to Examples of using dates as criteria in Access queries[^]
It should be
Date()

for today's date. instead of
Now()
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900