Newbie Help with if function
I have a table that has a field called "from" and another field called "value" which has a monetory value, I want to have a total value for (say) leaflets after a specific date. These are to be displayed on another layout which I have associated with the table.
I have created a calculation field (leaflet) with "If (From="leaflet" and Date >4/4/2009; Value ; 0 )" and a summary field (sum leaflet) with "total of leaflet".
It dosent calculate correctly and seems to sum all the leaflets regardless of date.
Its probably something stupidly simple but I cannot see what.