Related table creation

[daroloson]

My main table is a read-only external data source so I don't think I should be adding fields to that

but I want to generate a report with equipment in three groups based on entry date.

So my new related table only uses the date field "entered" from the main table and generates

a string field "Period" as follows with "Entered"

Case ( Entered < Date ( 12 ; 31 ; 2009 ); "Before" ; Entered > Date ( 6 ; 30 ; 2011 ) ; "Post" ; "During")

So the new related table should end up with every entry date from the external data source

and one of the three strings but I end up with zero records.

Dani Roloson

University of Waterloo