A
aminihojat
Hi all,
I have report1 that is opened by command button1 and its record source
comes from table1 :
Id fldname amount
1 smith 100
1 smith 100
1 smith 100
1 jack 100
2 mary 200
2 mary 200
2 mary 200
2 mary 200
report1: groups on Id field and sum for amount
id fldname amount
1 smith 400
2 mary 800
but I want to change smith to jack in the report1 like :
id fldname amount
1 jack 400
2 mary 800
how can I do it in vba or other solutions?
Thanks in advance
amini
I have report1 that is opened by command button1 and its record source
comes from table1 :
Id fldname amount
1 smith 100
1 smith 100
1 smith 100
1 jack 100
2 mary 200
2 mary 200
2 mary 200
2 mary 200
report1: groups on Id field and sum for amount
id fldname amount
1 smith 400
2 mary 800
but I want to change smith to jack in the report1 like :
id fldname amount
1 jack 400
2 mary 800
how can I do it in vba or other solutions?
Thanks in advance
amini