Monthly Archives: February 2013

SQL Server: Using Table Aliases In Delete And Update Queries

A couple of posts ago I said that I would blog about counting unique and distinct values using VBA. I promise I will get to that but today I want to talk about the syntax for using tables aliases in … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , | 1 Comment

Determine the Office Edition in VBA

A few years ago a user asked how to use VBA to determine the edition of the active session of Office. I’m not sure why this would be useful (perhaps to show as information on a userform?) but I duly obliged … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , | 2 Comments