Convert excel formula to Access formula

[mcAvero]

Hi there looking to convert the following excel formula to Access:

=IF([@[Pool_Standard]]="Current",SUMIF([SP ID],B5,[4201_SOH]),"See Current")

- Where "Pool_Standard" = Current
- Where "SP ID" is the same number eg. 1
- Then will SUM all values in "4201_SOH" in the first row, the remaining row to state "See Crurrent"
- Thus 4201_SPID_SOH, Total to equal 5 from the 2x rows listed (4+1)

Thank you for your help.



Sample Data

SP ID	Pool_Standard	4201_SOH	4201_SPID_SOH
1	Current	4	5
1	Alternate	1	See Current
2	Current	2	2
3	Current	1	9
3	Alternate	8	See Current
4	Current	2	3
4	Alternate	1	See Current
4	Alternate	0	See Current
5	Current	1	5
5	Alternate	0	See Current
5	Alternate	4	See Current
5	Alternate	0	See Current

 

[ranman256]

Make a query to sum the column,then join that query to your data table.

 

[mcAvero]

Good point, too focused on making the formula work... nice and simple...

Thank you.