<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())));