As one who has used MySQL since about 1998, MS Access since 1993, MS SQL Server since 2000, and have had to play with reporting from an Oracle database or...

Jeff Moden (10/5/2008)

---

"If you limit what they can read to simple views, you also keep control of the queries so they don't crush the server performance wise."

- and -

"You...

Agreed. As long as the end user sticks to...

Oiye...

Wow. I whole-heartedly agree! I am sitting...

I'd have to say the ability to throw down a model that creates in hurry is one of the nicer features of this particular tool. The one thing I...

Nisha (5/19/2008)

---

You're right, Iggy.. its not a glitch from what I can see.

I've faced this problem once before so I knew exactly what the question was about.

You can't...

Stephen Dyckes (9/24/2008)

---

When you really start considering all the possibilities, it starts spiralling quickly.

What will really need to occur, is a shift in the way the applications are written. They...

I find this article and the ensuing discussion highly entertaining.

As a contract/consultant, I have quite often been thrust into the midst of small to mid-sized companies that seem to be...

Jeff, great examples and test building. It amazes me you have the time to post such significant and applicable content and in such detail.

Thank you for your many contributions!

Thanks for the post Manie! Maybe there are better ways, maybe not. Either way, the discussion is useful.

Jeff Moden (8/26/2008)

---

Thanks for the code and the write up... it's exactly what I was afraid of though. In your example just for layer #1, if you have a...

Jeff Moden (8/25/2008)

---

Heh... agreed. But, would you mind posting...

Jeff Moden (8/23/2008)

---

If you want to suppress NULL's caused by missing data in a Pivot, there's no other way to do it than in the final Select. That's because...

Well, it seems I have nominated myself for the virtual public whipping. I have used Crosstab AKA Pivot queries in MS Access for so many years, that when I...

In MS Access you do not have to reference the ".Value" property to get the current value. Specify no property at all, and the data of the field should...