DocumentsDate added

XLCubed: First Steps in OLAPhot!

05.06.2007

If you use Excel for analysis of large amounts of data from your business systems you will be familiar with some of its limitations as well as its power. At XLCubed we produce products that help to bridge the gap between Excel’s power as a spreadsheet and its limitations as a place for analyzing and storing large amounts of data.

Hits: 125

• Details
• Download
• View

Using Pivot tables in Excel hot!

07.05.2007

Learn basic techniques to use Pivot Tables in Excel (Access).

Hits: 144

• Details
• Download
• View

Summing in reports: Sales, products

15.01.2008

Example access database sales on how to sum in reports. The following reports presenten:

Sales by Product

Sales by Product with Page Total

Sales by Product with Running Sum and Numbered Rows

Sales by Product with Running Sum at Group Level

Sales by Product with Running Sum

Hits: 33

• Details
• Download

Send mail from Access: VBA SendObject using Lotus Notes

04.06.2007

Use office automation to send emails from your Access applications.

Hits: 38

• Details
• Download

Fascinating Query Trickshot!

09.05.2007

Here is an overview of what we will cover:

• How to pass a variable parameter to a query calculation
• How to add "<All Employees>" to a list of employee names
• Use UNION query to add a Totals row to a dataset output

Hits: 104

• Details
• Download