Using Query to select day of week

[LDarling]

Hi,


First time on here and reasonably new to queries. I have a database and want to run a query that filters the database with two characteristics
Staff name and
Day of week.
So i am after all the database records that involve Rose (staff) and Saturday (Days).
I have figured how to get Query to show all records with Rose by putting "Rose" in Criteria in the Design View of the Query but I dont know how to get it to show only Saturday records for Rose.

Thanks for viewing.

Luke Darling

[ranman256]

format([date],"w") gives a number
Saturday = 7
so use 7 in the criteria and the format in the field.

[vicsaccess]

there may be better ways from the experts here but my method would be to format the date as a day of the week in a query then use the criteria field to narrow it down to which day you would like. try expr1:format([productiondate],"dddd")

[LDarling]

Thanks Ranman,
Just to clarify. With Rose I was able to just put Rose in Criteria Of Staff field but for specific day I need to create new field. So I cant just put in Criteria of Date field?

Thanks
Luke

[vicsaccess]

you have two options in your query, expression 1 is how ranman described and expression 2 was the way i described.