Query Not Working

[whjwilson]

I am running a query on one of my tables in my database but it is not pulling the information I am asking it too. Here is what I have so far.

Pass Issued by Date Issued
Jones Friday, March 10,2006
Franks Thursday, March 9, 2006


The date is formated to give me the Long date. I want to run a query to see for instance only passes issued on a Friday day. I have this for my SQL:

SELECT *
FROM Main
WHERE (((Main.Date_Issued) Like '*Friday*'));

Main is the title of my main table.

The query will not run as I thought it would and give me all the Fridays in the database. Any suggestions?

 

[Golom]

Presumably the database field "Date_Issued" is a DateTime field. If so, it doesn't actually contain the word "Friday" (its a number). You probably need something like

SELECT *
FROM Main
WHERE WeekDay(Main.Date_Issued) = 6

Days are numbered as 1=Sunday, 2=Monday, etc.

 

[whjwilson]

Thanks Golom, worked perfectly.