I have a query that includes several short date (6/19/2007)fields. How do I create a field withinthe query that only reads the year of the short date? Please be detailed in your response as I am a beginner. Thanks.
Tim
Advanced Beginner
Windows XP 
Access 2010 32bit
I have a query that includes several short date (6/19/2007)fields. How do I create a field withinthe query that only reads the year of the short date? Please be detailed in your response as I am a beginner. Thanks.
Tim
Expert
Windows 7 64bit Access 2010 32bit
Year(YourDateField)
Advanced Beginner
Windows XP Access 2010 32bit
Could you be a little more specific? where does year(DOI) go? Expression builder? Criteria line? Thanks.Originally Posted by amrut
VIP
Windows XP Access 2007
Yes, use the Expression Builder in your Query to build this calculated field.
If you need more help, try doing a Google Search on "Creating Calculated Fields in Access Queries". You will find lots of tutorials and YouTube videos showing you how to create Calculated Fields in Queries.
Expert
Windows 7 64bit Access 2010 32bit
a new field in query
If Then Expressions?
Posting Permissions
Reply With Quote