sychoangel
04-21-2010, 05:54 PM
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 (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!
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 (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!