three leters abbr for Day of week

[gal]

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

 

[Duane Hookom]

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

 

[Peter R. Fletcher]

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.

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