You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
After you've built a few Access database applications, you inevitably come up against this problem: the arrangement of your data in tables is not the arrangement you want on reports. Frequently, values appear vertically in a table, but you want them to appear horizontally on the report. Luckily, crosstab queries provide a quick way to "pivot" the data to the way you want it. Luke Chung of FMS, Inc. provides a great tutorial on crosstabs in this article on the FMS site.
Check out more Access papers, tips, and video from FMS.
Comments: (1) Collapse
Crosstab Queries are one of my favourite aspects of Access. Just keep in mind that this is Jet SQL syntax and not supported in other environments, e.g., T-SQL. Nice write-up.
Comments: (loading) Collapse