the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
In a query you can create two fields. There is probably someone here who can do it off one field but if not the following works.
In the follow example, which I have copied from my data base the date is in a field called [Days]
The first calculated field that is made in the query is
The created field WDay returns a number. It is 1 for Sunday through to 7 for Saturday.
The next field that is created returns the words such as Sunday, Wednesday etc
DayName: IIf([Wday] Like 1,"Sunday",IIf([WDay] Like 2,"Monday",IIf([Wday] Like 3,"Tuesday",IIf([WDay] Like 4,"Wednesday",IIf([WDay] Like 5,"Thursday",IIf([WDay] Like 6,"Friday",IIf([WDay] Like 7,"Saturday")))))))
So when you look at the query that is opened you see