Simple Date Filter 1

[MattGreer]

I searched and I feel so ignorant... I'm trying to filter a list of songs that were performed this calendar year. Here's the query:

This one works but doesn't filter by date:

SELECT tblSongs.Title, tblEvents.Date
FROM tblSongs INNER JOIN (tblEvents INNER JOIN tblHistLink ON tblEvents.EventID = tblHistLink.EventID) ON tblSongs.SongID = tblHistLink.SongID
ORDER BY tblEvents.Date DESC , tblSongs.Title, tblEvents.Date;

Here I tried to filter using =Year(Now())

SELECT tblSongs.Title, tblEvents.Date
FROM tblSongs INNER JOIN (tblEvents INNER JOIN tblHistLink ON tblEvents.EventID = tblHistLink.EventID) ON tblSongs.SongID = tblHistLink.SongID
WHERE (((tblEvents.Date)=Year(Now())))
ORDER BY tblEvents.Date DESC , tblSongs.Title, tblEvents.Date;

Here I tried to filter using =Year(Date())

SELECT tblSongs.Title, tblEvents.Date
FROM tblSongs INNER JOIN (tblEvents INNER JOIN tblHistLink ON tblEvents.EventID = tblHistLink.EventID) ON tblSongs.SongID = tblHistLink.SongID
WHERE (((tblEvents.Date)=Year(Date())))
ORDER BY tblEvents.Date DESC , tblSongs.Title, tblEvents.Date;

Obviously the last two returned empty results.

I feel so dumb. I appreciate your help!!



Thanks!!


Matt

 

[SkipVought]

Hi,

WHERE YEAR(tblEvents.Date)=Year(Date)

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[MattGreer]

It's funny, when I just looked at the SQL I realized what the problem was but I still didn't know what the right syntax would be. You're amazing Skip. Is there anything you don't know???



Thanks!!


Matt

 

[SkipVought]

Oh, yes. Lots anf lots!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[MattGreer]

Well shoot, I just got around to implementing your fix, and I'm getting the whole list and not just the songs that we performed this calendar year.

SELECT tblSongs.Title, tblEvents.Date
FROM tblSongs INNER JOIN (tblEvents INNER JOIN tblHistLink ON tblEvents.EventID = tblHistLink.EventID) ON tblSongs.SongID = tblHistLink.SongID
WHERE (((Year([tblEvents].[Date]))=Year([Date])))
ORDER BY tblEvents.Date DESC;

Not sure... what to fix...

Thanks!!


Matt

 

[MattGreer]

Hey, I figured it out! I used

WHERE (((Year([tblEvents].[Date]))=Year(Now())))

Thanks!!


Matt