Set Day Name by Date

[DaniBoy]

Hello Guys,

Thank you for all the help you have giving me, I now have a full time job as a database manager and I am desinging some new databases for the Alachua County Waste Collection Office in Gainesville Florida. You guys are the best help I have ever gotten for access. Not even my teacher explains as good as you guys do, and you write it on here, he is face to face!!! Anyway special thanks to Pat. RV, Rich and all that have answered my posts. Now for the quiestion!!!!

I want to have a field that will tell me the day of the week "Monday-Sunday" depending on the Date 06/05/2002. How do I do that. Could be in a query.


Thank you
DaniBoy

 

[DaniBoy]

Thanks Pat

I am sorry about the question, I tried looking at the windows help and I searched under set day name. I had a mind block from sitting in front of the computer for about 5 hr straight working on this database!!! Once I saw your post, I felt realy stupid!!! Thanks for tracking me back into place!!! jajaja

DaniBoy

 

[Rummy]

This is my first day using Access and I'm going nowhere fast. Please help me understand in the simplest terms, I'm a greenhorn.

I'm creating a form, the first text box is "Date:". In the properties I have the "Control Source" as "=Date()" and it works just fine (at least for today, we'll see about tomorrow ). It auto-calculates/completes the proper mm/dd/yyyy for me.

Now, I'd like to have a "Day:" text box next. (should it be a text box??) No matter what I try, I can't get it to auto-complete the weekday name as in "Monday" How do I do it?

I'm using Access in Office XP Pro and know nothing of scripting, I'm a firefighter by trade. Many thanks in advance!

-Doug-

 

[Rich]

just add an unbound textbox to your form, set its control source to =Date(), set the format to DDDD.
seems a strange request though, don't users know what day it is?

 

[Rummy]

just add an unbound textbox to your form, set its control source to =Date(), set the format to DDDD.
seems a strange request though, don't users know what day it is?

You don't know how much I appreciate the help! I kept getting "#NAME?" or something like that in the field every time I tried something.

We're firefighters, we only work every third day, its hard to keep track.

Really, THANKS!

-Doug-

 

[Rummy]

Along the same lines, what can I add to =Date() to allow the date to be edited manually while completing the form? Like when a report is started after midnight but applies to the previous day?

 

[Rich]

Set the Default entry to =Date() and not the control source, I would suggest that you do not name the field or the control Date, it's a reserved word in Access and will cause problems.