If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
three leters abbr for Day of week
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 |
#3
|
|||
|
|||
three leters abbr for Day of week
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 =--- |
Thread Tools | |
Display Modes | |
|
|