Getting the sum of all orders this year

[SteveGriff]

Hi peeps

Quick question

I have a date field. Basically I want a Calculation field to look at the date field and add up all dates that have 2002 in it. Therefore if there are 3 dates that contain ??/??/2002, the calculation field will add up to 3.

Hope that's a good enough description

Thanxs

Steve Griff

[LiveOak]

I'm going to assume that you REALLY don't want this to work only for 2002. First create a calculation field:

CalcYear (calculation, number) = Year(DateField)

Then a global field:

gYear (global, number)

Create a relationship matching gYear <--> CalcYear

Then add up the related records:

Count (calculation, number) = Count(YourNewRelationship::Year)

You can really do this with two fields for just 2002, but it is good practice to change DATA and not STRUCTURE to alter the calculation for 2003.

-bd