Field based on day of week (1 Viewer)

[colmtourque]

I am creating a table with one field that is currently text but that really needs to be the day of the week. Is there a formatting for that I looked under date and time but nothing there really seems to help this situation.
Thanks

 

[raskew]

Being unsure whether you're looking for the numeric weekday as in Sun = 1, Mon = 2, etc.,
or the character expression, here are examples
for extracting either:
<From the debug window>

'Specify a date
mydate = #10/01/02#

'Display the numeric weekday
'(lookup Weekday() function)
? weekday(mydate)
3

'Display the abbreviated character expression
? format(mydate, "ddd")
Tue

'Display the full character expression
? format(mydate, "dddd")
Tuesday

 

[colmtourque]

Sorry let me further explain, (it has become more complicated)
I need a table with the following
Table Field
Everyday
Monday
Tuesday
Wednesday
Thursday
Friday
Monday Wednesday Friday
Tuesday and Thursday

When I used this though and do a Group By for sorting of course it comes up with a rather bad order.

Instead I used numeric fields to represent the values and then tied it to another Table such

Table Field Field Represents
0- Classes Held Everyday
2- Classes Held Monday
3- Classes Held Tuesday
4- Classes Held Wednesday
5- Classes Held Thursday
6- Classes Held Friday
8- Classes Held Monday Wednesday Friday
9- Classes Held Tuesday and Thursday

Now it does sort better but I am looking to see if their is a better way.

 

[ColinEssex]

Isn't this the same post that is in the Forms forum?

Col

 

[colmtourque]

Kinda, I am attacking the problem from different angles, and thought that would be the best way to go about it. The table idea hit me first so I was trying to see if I could redo the table. But then as I was working on it, I changed the form format and decided to see if I could make the form work instead. I hope that was not innapropriate, but I did not want to ammend my questions as one is about how to do it on a form and the other about how to do it in a table. So it made sense to post seperatly.