C CharlesCount via AccessMonster.com Jul 23, 2007 #1 I would like to add a field in a query just to dispaly the day of the week for a particular recor Thanks
I would like to add a field in a query just to dispaly the day of the week for a particular recor Thanks
A Allen Browne Jul 23, 2007 #2 If the field is named Date1, type this expression into a fresh column in the Field row: Format([Date1], "dddd") Use "ddd" if you just want the first 3 letters of the name.
If the field is named Date1, type this expression into a fresh column in the Field row: Format([Date1], "dddd") Use "ddd" if you just want the first 3 letters of the name.
