Click events do NOT exist in Access reports. If you want true drill-down capability, you need to either build a data access page in Access (a tiresome exercise in...

OK, this one is a little trickier.

DECLARE @p tinyint -- Stores the period we are looking for

DECLARE @y smallint -- Stores the year we are looking for

SET @p = 2

SET...

OK, I'm making an assumption here that the last two letters of the GL_Name_VC will always uniquely identify the Sales Category. If that is not the case, then you...

First, I would highly recommend that you leave the "Net Asset" line to your front-end reporting solution. SQL is decidedly sub-optimal for sophisticated data display. In Crystal or...

OK, Jeff, how did KH do it right?

Suppose the table is:

A 1 *

B 2 @

C 3 #

As I read it, Parmesh wanted:

A B...

Given that the included query includes a bunch of stuff not seen in the sample data, I'm going to assume you're simplifying things. Hence, I'm not going to point...

KH, I don't think that will quite do what Parmesh wants. That union won't transpose the table. It will just concatenate all the information into one long column.

Parmesh,...

You may have better luck exporting the raw data to Excel, and then using a pivot table in Excel.

Or you could look into OLAP cubes.

Dynamic cross-tab queries are, in my...

You could try something like:

SELECT MONTH(f.service_date) AS service_month, YEAR(f.service_date) AS service_date,

SUM(CASE fm.sex WHEN 'M' THEN 1 ELSE 0) AS total_male,

SUM(CASE fm.sex WHEN 'F' THEN 1 ELSE 0) AS total_female

FROM family...

For me, personally, the biggest sticking point was understanding the differences between views, stored procedures, and user-defined functions. In Access, these are all accomplished with either a generic query,...

How often do you add new metrics? If it's two or three times a month, then, yeah, you have a need for a dynamic system. If it's once...

Just for the record, it might be possible. I know that I can store VB code in a table, and execute it (don't ask, it was a complicated situation...

Could you clarify this? Is this just a single-column table with a list of the positive integers?

OK, follow-up question here, that relates to something I've been doing.

As I read this code, it will end up listing the dates for which the employee has a record, and...