three leters abbr for Day of week

Hi group,

I have a report that runs totals accompanied with the date
and the day of the week. All my days are being displayed
with three letter abbreviation such as
TUE, MON,WED,THU , all but Friday(FRID). Is there a way to
alter Criteria in my query to force Access to display only
FRI when I run my report.

I tried by resizing the column , but I'm losing D on WED
and N and MON....

Thanks guys

galin

What type of value is actually stored in the table? If it is a date value,
just use Format([DateField], "ddd").

--
Duane Hookom
MS Access MVP


"gal" wrote in message
...
Hi group,

I have a report that runs totals accompanied with the date
and the day of the week. All my days are being displayed
with three letter abbreviation such as
TUE, MON,WED,THU , all but Friday(FRID). Is there a way to
alter Criteria in my query to force Access to display only
FRI when I run my report.

I tried by resizing the column , but I'm losing D on WED
and N and MON....

Thanks guys

galin

It looks as if the contents of your day of the week control is
actually formatted as "Monday", "Tuesday", etc. If the control
actually contains a date and its just the formatting that is wrong,
follow Duane's advice. If it's a text string that is created elsewhere
(e.g. in the source query for the report) and you don't want to change
the source, you can use "=Left$(OriginalField,3) as the control source
in the report.


On Tue, 25 May 2004 12:54:49 -0700, "gal"
wrote:

Hi group,

I have a report that runs totals accompanied with the date
and the day of the week. All my days are being displayed
with three letter abbreviation such as
TUE, MON,WED,THU , all but Friday(FRID). Is there a way to
alter Criteria in my query to force Access to display only
FRI when I run my report.

I tried by resizing the column , but I'm losing D on WED
and N and MON....

Thanks guys

galin

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher


----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---