three leters abbr for Day of week

  • Thread starter Thread starter gal
  • Start date Start date
G

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
 
What type of value is actually stored in the table? If it is a date value,
just use Format([DateField], "ddd").
 
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
Click to expand...

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