Counting unique Records and showing total in Header (not Footer) [Access 2007]

[sychoangel]

Hello,

Firstly i'd like to say : Thank God this site exists - reading through posts has helped me soooo many times

I need some help with Counting unique Records and showing total in Header (not Footer) [Access 2007]

My report is grouped by TicketNo and each ticket can have multiple LineItems... using the posts in this forum, i have been able to count the number of unique TicketNo's and show the total in the report footer...

Is there any way to show this in the header instead? I have found this post but it seems to only apply to Access2000 & not 2007
http://www.access-programmers.co.uk/forums/showthread.php?t=44326&highlight=sum+unique+records+header

In the header I can easily count the number of LineItems by simply using a =count(*) but no matter what i do, i cant get the total number of unique TicketNo to show... it always comes back with a 1

Any guidance would be greatly apreciated!

 

[HiTechCoach]

Hello,

Firstly i'd like to say : Thank God this site exists - reading through posts has helped me soooo many times

I need some help with Counting unique Records and showing total in Header (not Footer) [Access 2007]

My report is grouped by TicketNo and each ticket can have multiple LineItems... using the posts in this forum, i have been able to count the number of unique TicketNo's and show the total in the report footer...

Is there any way to show this in the header instead? I have found this post but it seems to only apply to Access2000 & not 2007
http://www.access-programmers.co.uk/forums/showthread.php?t=44326&highlight=sum+unique+records+header

In the header I can easily count the number of LineItems by simply using a =count(*) but no matter what i do, i cant get the total number of unique TicketNo to show... it always comes back with a 1

Any guidance would be greatly apreciated!

I use this trick:
Sub Report Tips and Tricks

 

[Galaxiom]

Firstly i'd like to say : Thank God this site exists - reading through posts has helped me soooo many times!

AFAIK God plays no part in constructing, hosting or contributing to this site. Being omniscient He could be really useful but alas no posts.

 

[sychoangel]

I use this trick:
Sub Report Tips and Tricks

Thats Wonderful & Easy Thankyou very much for your help!

 

[HiTechCoach]

Thats Wonderful & Easy Thankyou very much for your help!

You're welcome.

Glad you found it helpful.