Day() function in Access

[shansakhi]

Dear All,
I am very new to Access. Need your help to know how to change Date to Day i.e. 1,2,3.....31 with Day() function.
Please assist me step by step.

Regards,
Shan

 

[Joe4]

You would use a calculated field, i.e.
MyDay: Day([DateField])

See here for details, explanations, and examples: https://www.techonthenet.com/access/functions/date/day.php

 

[shansakhi]

Thank you so much.
I have already gone through this website but due to very limited knowledge I am unable to understand about the query. Hence request your assistance how to create this query.

Regards,
Shan

 

[Joe4]

While we can help you with specific problems, we cannot teach you how to use Access, in general. This website isn't really set-up for that.

Creating queries is one of the most fundamental, basic, and important things you use in Access.
There are tons of tutorials, books, and videos out there that can teach you those things. Most can be found very quickly with a Google or YouTube search.

Try searching on: Creating queries in Access
and then after that you can search for: Creating Calculated Fields in Access Query

Also, any beginning Access book will contain all these details.

All these options are much more detailed than anything we can provide in a response here.

 

[shansakhi]

Thank You So Much!

 

[Joe4]

You are welcome.