I'm trying to query a database table based on 2 factors, in my case, Car and Year.
I can do the car which is no problem, but am having difficulty getting the date/year part correct - can anyone please help.
The date format is dd/mm/yy, and I want the user to select a year from a drop down menu, say 2002, then the form show all events for a certain car in the selected year.
My query at the moment is (the date part of which doesn't work) :
SELECT * FROM tblRace
WHERE (CarId = ::CarId::) AND (RaceDate=::RaceDate::)
ORDER BY RaceDate DESC