[AccessD] Columns with composite data

Bert-Jan,
I tried both.  The page footer gave me "#error" on each page.
The group footer gave me a total for each record.  
But... that got me to thinking -- after your email, I might add.
In the query, I created a field ( CNT: IIf(IsNull(LastName),1,0) ) so all the results would be the same.  I then created the group footer using the name of the new field.  It worked!  I now have the Total at the bottom of the last column.
Thanks.
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bert-Jan
Brinkhuis
Sent: Friday, September 03, 2004 3:33 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Columns with composite data


Hi Jim,

you have probably tried this, but you didn't mention it (and i didn't test
if it is working for you!) but have you tried a page footer? Or maybe a
group footer?

HTH

Bert-Jan

----- Original Message ----- 
From: "Jim Hewson" <JHewson at karta.com>
To: "AccessD" <accessD at databaseadvisors.com>
Sent: Tuesday, August 31, 2004 5:15 PM
Subject: [AccessD] Columns with composite data



Just curious if anyone has done this before.
I created a report with four columns.  The columns run down, then across.
The fourth column of page 3 is about half way down the page in length.
Is it possible to use the remainder of the column space for a composite
data?
E.g. total number of records or something similar.
If put in the Report footer, a new page is generated.
I currently put such information in the Report Header.

Thanks,

Jim



----------------------------------------------------------------------------
----


> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com