Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me

Microsoft Access 223
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

Crosstab and Union Queries, Query Wizards, Advanced Query Properties and Functions, SQL Primer, More.

Permanent Link
Course Link: Microsoft Access 223
Keywords: access query crosstab union
Post Reply

Comment from Alex Hedley @ 5/6/2010
Hi :)
Is there a way to make the Crosstab Query show in a Form or made into a Report or is it easier just to use Pivot Tables?

Reply from Richard Rost:

Since the column headers will change in a crosstab query, you're better off using a PivotTable or PivotChart... unless you're SURE they're not going to change, then sure - build a form based on your crosstab query.
Show Just This Thread        Post Reply
Comment from Richard Rost @ 11/2/2009
No, a cartesian product is every record from table 1 paired up with every record from table 2. A many-to-many relationship is SPECIFIC records from table 1 joined to records from table 2 using a relationship specified in table 3.
Show Just This Thread        Post Reply
Comment from TBone @ 11/1/2009
Is a Cartesian Product the same as Many-To-Many?
Show Just This Thread        Post Reply
Crosstab Query Comment from Mimi Bailey @ 11/26/2008
Richard, Is it possible to build a crosstab query which would have more than 3 row headers.  The wizard constrains us to 3.  Is there a work around for this?  
Show Just This Thread        Post Reply
Comment from Elsa @ 11/14/2008
Thank you Richard,
I renamed the system.mdw file and that allowed me back into my database.  For now I will keep away from any security options.
Show Just This Thread        Post Reply
Comment from Richard Rost @ 11/14/2008
Elsa, I have not covered Access User-Level Security in any of my tutorials as of yet (see my recent Blog post for reasons why). Depending on how "tight" you secured your database, there are a couple of things you can try. The easiest is just to create a new Workgroup file, or attach to the default System MDW file. If you didn't lock down all of your objects, that might work. You can also try importing your objects into a new blank database. If this doesn't help, contact me via the TechHelp page and I'll try to assist you further.
Show Just This Thread        Post Reply
Comment from  Elsa @ 11/11/2008
Hi Richard,
I played around with the security settings on my access database and now I locked myself out of my own database.  I can access the database from my colleague’s computer (without being prompted logon information) but not from my own.  Access prompts a logon message box on my computer but my password is being denied.  Do you discuss security options in future tutorials and if not, will you please help me with this issue?
Show Just This Thread        Post Reply
checkbox Comment from Richard Rost @ 9/19/2008
Joel, I'm not sure I understand your question. You want to click on a checkbox and change the value of a textbox? You can do that with an AfterUpdate event which I cover in Access 207 (as a macro) and Access 303 (as an Event Procedure).
Show Just This Thread        Post Reply
checkbox Comment from joel torres @ 9/18/2008
what is the procedure when you checked the checkbox a message will appear on the textbox on the form view?
Show Just This Thread        Post Reply
Comment from Richard Rost @ 5/24/2008
Walter, yes... but make sure you type it in as two words: "Is Null" not "IsNull". The latter is a function, like IsNull(FirstName), whereas in a Query paramter, you would type in "Is Null". Confusing, I know.
Show Just This Thread        Post Reply
Comment from Walter Pohle @ 5/16/2008
If you have missing data like address field can you put in IsNull in Criteria
Show Just This Thread        Post Reply
Comment from Richard Rost @ 2/28/2008
Use a FIND-DUPLICATES query. We learn about them in Access 223, lesson 4. If you then need to go back and delete some of those duplicate values, use a DELETE query from 222.
Show Just This Thread        Post Reply
Comment from  lehu @ 2/26/2008
what is the procedure for deduping table against another table?
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 8+8:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



You may want to read these articles from the 599CD News:

8/15/2019Last Chance for Access CDs
8/1/2019Customer List Form Template
8/1/2019New Template Access Customer Database
7/30/2019Microsoft Access Developer 13
6/20/2019TIP: Validation Rules in Access
11/20/2018Microsoft Access Developer 12
8/25/2018NEW: Access Dev 9, 10, 11
8/25/2018Microsoft Access Developer 11
8/25/2018Microsoft Access Developer 10
8/25/2018Microsoft Access Developer 9

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP