three leters abbr for Day of week

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
 
D

Duane Hookom

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