What are the various built- in functions for doing calculations in MS Access?
Answer Hello Girish, In a regular SELECT query you can use all the access functions for the selected fields, and in an aggregate query (GROUP BY), you can use AVG, SUM, COUNT, MAX, MIN & others – see lookup in QBE You can find all the functions in onboard help – type in ‘functions’ into the search field (assuming Access 2003) The Default Value property provides a value when a new record is created and no value is specified in the INSERT query, or when entering data via a table or form. Concerning sorting – generally data is only sorted on output for display purposes (The database stores data records in an ad hoc order and there is no way and no point in trying to manage this). Sorting is achieved using the ‘ORDER BY’ clause in a SELECT statement eg: SELECT aaa, bbb, ….. FROM tblTable ORDER BY aaa ASC, bbb DESC the above would sort by aaa ascending then bbb descending Or – via the QBE, by selecting Ascending/Descending on the ‘Sort’ row of the query matrix. Or, if via a form, query or
