I am experienced using SQL in Oracle but have found some difficulty writing reports in Access, not sure if I am making syntax errors or the functions I am using aren't not compliant with Access.
Was wondering if there were some good resources you guys could recommend with Access SQL examples and possibly list of functions that do and do not work. Particularly having trouble with CASE statements, Dense Rank, and some aggregate functions.
I do little in Access myself (MySQL/SQLSvr) but this site is a good-un: http://www.techonthenet.com/access/functions
The more experience Access guys here will have other links I'm sure.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks