Access Date and Day issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1720103%22%20slang%3D%22en-US%22%3EAccess%20Date%20and%20Day%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1720103%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20automatically%20populate%20and%20show%20the%20%22Day%22%20in%20a%20separate%20field%20which%20corresponds%20to%20the%20date%20chosen%20in%20the%20date%20field.%3C%2FP%3E%3CP%3Eie.%20select%2028%2F09%2F2020%20in%20date%20field%20and%20also%20populate%20the%20day%20field%20to%20show%20Monday.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1720103%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1720250%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Date%20and%20Day%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1720250%22%20slang%3D%22en-US%22%3EUse%20another%20unbound%20control%20and%20use%20the%20Format%20function%20to%20display%20the%20value%20in%20the%20format%20you%20would%20like.%3CBR%20%2F%3E%3CBR%20%2F%3E%3DFormat(%5BFieldName%5D%2C%20%22The%20Format%20You%20Want%22)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1733837%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Date%20and%20Day%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1733837%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20reply.%20The%20way%20I%20need%20the%20info%20is%20having%20a%20date%20field%20and%20a%20day%20field.%20At%20present%20I%20choose%20the%20day%20from%20a%20drop%20down%20but%20want%20to%20automate%20it.%20When%20I%20choose%20a%20date%20%2C%20I%20want%20the%20day%20to%20populate%20another%20field%20.%20The%20idea%20is%20that%20later%2C%20I%20can%20use%20the%20day%20field%20for%20employee%20daily%20work%20loading%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F459380%22%20target%3D%22_blank%22%3E%40Daniel_Pineault%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

How can I automatically populate and show the "Day" in a separate field which corresponds to the date chosen in the date field.

ie. select 28/09/2020 in date field and also populate the day field to show Monday.

4 Replies
Use another unbound control and use the Format function to display the value in the format you would like.

=Format([FieldName], "The Format You Want")

Thanks for the reply. The way I need the info is having a date field and a day field. At present I choose the day from a drop down but want to automate it. When I choose a date , I want the day to populate another field . The idea is that later, I can use the day field for employee daily work loading @Daniel_Pineault 

Hi,

 

you don't need a separate field (in the table) for the day as you can always let it be shown from any date you have. e.g. to show the day in a separate text box on the form:

 

  1. create a new text box and set its control source to: =YourDateField
  2. set the Format property of the text box to: dddd

So, to show the day is just a matter of formatting the date.

 

I'm not sure that I get exactly what you mean by

> ...later, I can use the day field for employee daily work loading

 

If this means you have to "extract" and analyze the days you probably can use the Weekday function e.g. in a calculated column of a query.

 

Servus
Karl
*********
http://AccessDevCon.com
Access FAQ (German/Italian): http://donkarl.com

@Karl Donaubauer  I created a query to show employee jobs per day. I then use this to generate a report which shows me which employee to use next. This enables me to not overuse one employee.  

What I want is when I choose the date using the date picker it automatically pulls in the day for that date chosen.