'white out' duplicate dates

[Cateleb]

Hi, sorry if this has come up before, I've trawled through the posts but can't find a solution

I've an Activity table with Date, Time, and Activity fields .. the data is filled in using one layout but I've another layout for printing it and on this print layout I want only the first of duplicate Dates printed and thought using conditional formationg to turn the date white would be a solution (i've used this elseswhere in the program and it works fine as we print only to white paper)

at the moment I get

17/5/2012 9.00 checked doors 1 & 2

17/5/2012 9.15 checked doors 4 &15

18/5/2012 8.14 checked doors 3, 4 &5

I would like it printed

17/5/2012 9.00 checked doors 1 & 2

9.15 checked doors 4 &15

18/5/2012 8.14 checked doors 3, 4 & 5

ie, the the text of the date field in the second record to be white

I've tried various thngs - list(), position(), self join relationships, get(recordnumber) etc but seem to be going round in circles so presume i'm misisng something

any help thanks

Edited November 2, 2012 by Cateleb

[comment]

The easiest (and fastest) way would be to group your records by date, and print them as:

17/5/2012

• 9.00 checked doors 1 & 2

• 9.15 checked doors 4 &15

18/5/2012

• 8.14 checked doors 3, 4 & 5

using a sub-summary (by Date) part.

To do it your way, try formatting the Date field conditionally using =

Self = GetNthRecord ( YourTable::Date ; Get (RecordNumber) -1 )

as the condition.

[Cateleb]

Thanks Comment, the 'self =..' thing works (still working out how .. think I'll need to dumb down my profile a tad from intermediate !)

I actually hadn't thought of the sub-summary, we've been using xls to do the activity logs for the past 10 years and I was blinkered into merely reproducing that look