G
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
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