Create a bookmark

[#1]

I have a report based on sales YTD. How do I create a bookmark that show all customersnumbers

that has YTD>4000. My calculation for YTD is  Sum({$<$(vSetYTD)>} [DebPris]/100) .

To be able to create a bookmark I tried to connect a macro to a button to achieve the right customers and then

create the  bookmark of it, but I always get all customers.

sub StatKunder

set f=ActiveDocument.GetField("[KundNr]")

f.Select "Sum({$<$(vSetYTD)>} [DebPris]/100)>4000"

end sub

What do I do wrong or is it an easier way to do it?

kindly

Håkan

[Gysbert_Wassenaar · Accepted solution]

Add a Select in Field action to the button and use your field KundNr and search string ='=Sum({$<$(vSetYTD)>} [DebPris]/100)>4000' as parameters. And add a Create Bookmark action to the button too. No need for macro's.