day of week

[Guest]

I have a series of dates (ie 1/1/2005 through 6/30/2005). I used the "dddd"
formatting to tell me what day of the week each date falls on (ie 6/18/2005
is Saturday, 6/1/2005 is Wednesday).

I need to list on a report only the information that is on a Saturday.
However, though "Saturday" appears in the field when I put the cursor over
the field and click "Saturday" changes to 6/18/2005 in the field. When I run
a query on the field using criteria of "Staurday" I get nothing back. When I
run a query on the field using criteria of "7" I get dates that have seven's
in them.

HOw do I get only "Saturday" info to appear?

Thanks,

Paul

 

[Rick Brandt]

I have a series of dates (ie 1/1/2005 through 6/30/2005). I used the
"dddd" formatting to tell me what day of the week each date falls on
(ie 6/18/2005 is Saturday, 6/1/2005 is Wednesday).

I need to list on a report only the information that is on a
Saturday. However, though "Saturday" appears in the field when I put
the cursor over the field and click "Saturday" changes to 6/18/2005
in the field. When I run a query on the field using criteria of
"Staurday" I get nothing back. When I run a query on the field using
criteria of "7" I get dates that have seven's in them.

HOw do I get only "Saturday" info to appear?

You can't apply criteria to a format. You need a calculated field that
actually returns "Saturday". Add a field to the query...

DayOfWeek: Format(DateFieldName, "dddd")

And put "Saturday" as the criteria under that new column.

 

[TPratt]

Weekday([Your Date Field]) will return the number day of the week (1 thru 7)
Saturday being 7.