February 19, 2010 5:38 PM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaAt this point, we have everything we need for about 95% of user reporting and analytical requests. On rare occasions we need to summarize the data prior to putting it into our Excel spreadsheets. This happens when the raw detail for an expected time frame exceeds Excel's normal 65,536 row limit...
February 9, 2010 9:23 PM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaLast post showed the Fields Table column holding Excel Formulas to embed into your database result sets. We also talked about how to enter formulas that reference database fields. This is truly powerful stuff that turns basic data extracts into analytical information. So let's start adding...
February 6, 2010 5:37 PM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaIt's great that we can download and display data in Excel where users can sort it, filter it, print it... whatever they want to it. It's great that we can summarize that data in interactive pivot tables. It's great that we can display those pivot tables in interactive charts. Those of you...
February 2, 2010 5:57 PM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaSometimes we want to include large fields in our results but don't want them hogging screen realestate. We can limit those results using the "Width" colum in our Fields Table (See below). If you couple this with the Format "W" (Wrap), you can display comments and notes...
