Weekday function problems Access

[bluey]

hello im trying to make my weekday function work.

First i tryed to create an array of names. this does not work all the dates have the same name. sunday seven times. no good unless you like sunday.

Next i put the weekday nos and names in a table and tryed to get them to show that .this did not work because my append query does not want to update a table with a select query.

Basically i need the week names to update to the correct dayno
e.g.
1) sunday 2) monday 3) Tuesday4) Wednesday 5) Thursday 6)friday 7) saturday

 

[[nateobot]]

I guess I don't know what your question is. If you are trying to find the day of the week from a date you can use this in code:

Format(YourDateHere, "ddd")
[code]

ddd gives you the first three letters of the day.  

dddd gives you the whole name of the day.

 

[bluey]

yes i admit i don have much success with explinations but thanks ile try that.

i was trying to get my days to display

Dude that's great considering im pants at explinations that worked exactly the way i wanted.

thanks