I have a query which calls a function, the function returns some values and at same time does some error trapping and inserts data into a log table.
Select countryCode, GetName(countryCode) from countryTable;
GetName( ) will look for some data in some other table, if found it will return the...
This cannot be done in a single query. Break it into two parts.
In modules, create a function whose parameter is ActivityNo. In the function, write code to fetch comments and concatenate them. The return value of this function will be this long string.
In Queries section, write a select stmt...
The requirement is to write a query where on one column the retreived data should contain the first letter to be capitalized. The required functionality is same as PROPER function of Excel. This has to be done in MS Access. Any suggestions ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.