answersLogoWhite

0


Best Answer

Use the YEAR function, which can extract the year of a date. If your field was DOB in the query you'd have MONTH(DOB) in the field row of the query.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you get just the year number in a query in Microsoft Access 2010?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Which extension identifies a file as a Microsoft Access 2010 database?

.accdb is the extension used for Access 2007 and 2010.


What is dedicated database application that is a part of MSOFFICE 2010 is?

Microsoft Access 2010.


Does Microsoft Office 2010 have Microsoft Access in its program?

Yes, Microsoft Office 2010 does have Microsoft Access in its program. Microsoft Office 2010 is a suite of software programs developed by Microsoft, which includes programs like Microsoft Word, Excel, Powerpoint, Outlook, and Access. Access is a relational database management system used for storing and retrieving large amounts of data. It is commonly used for organizing and managing data in businesses, schools, and other organizations. Therefore, if you are looking to purchase an affordable and easy-to-use upgrade key for Microsoft Office 2010, you can check out websites like Softwarekey4u. com, which offer a wide range of upgrade keys for various Microsoft products, including Microsoft Access. These websites often have user-friendly interfaces and offer a hassle-free process for upgrading your Microsoft product key.


What is office suite 2010?

Microsoft Office suite 2010 is a package that contains a selection of Microsoft Office Products. This includes Word, Powerpoint, Excel and Access.


How much can one expect to pay for the Microsoft Access software package?

For the Microsoft Access software package you can expect to pay from $80-120 online for the 2013 version. The version of Microsoft Access software package from 2010 is around $40 online.


Which type of object is used to organize and store data in Microsoft Access?

Which type of object is used to organize and store data in Microsoft Access 2010?Read more: Which_type_of_object_is_used_to_organize_and_store_data_in_Microsoft_Access_2010


Difference between Microsoft access 2003 and 2007?

differenciate the Microsoft access 2003 with 2007and 2010?


MicrosoftODBC Microsoft Access Driver invalid cursor state?

comopatible con ofice 2010


In a 30 record result set if the LIMIT clause is set to LIMIT 2010 how many records will the query return?

The idea here is that the query returns either the number of records which match the query, or the number of records specified in the LIMIT clause - whichever is less. In this case, 30 is less than 2010, so all 30 records will be returned.


Where can you find the answer for the Shelly cashman series of Microsoft Access 2010?

how to get the percentages to change amount of payment in each column


What exactly is the pro 2010 about?

Pro 2010 probably refers to Microsoft Office Professional 2010. This is a software package that includes Word, Excel, PowerPoint, Access, Publisher and Outlook.


What are the parts of Microsoft access windows?

Worksheets, charts, databases, and web support.1. Workbooks and Worksheets2. Charts3. Tables4. Web Supportas per Shelly Cashman Series Excel 2007 textbook. p.EX2