November 27, 2008 at 3:28 pm
Hello
This massage may appear to you as a spam, but actually i don't know what is the exact question i should ask.
I have this situation - i've got 20 commodities with their records price for 1 good and quantity. I've put yes/no field for every commodity and now i can calculate the price of the ticked commodities. I would like to print ONLY that commodities ( the ticked ones ). For example if i 've chosen 5 goods it should appear this 5 and next to every of them their price and quantity in the report.
Thank you in advance.
November 27, 2008 at 6:45 pm
Something like this:
DIM s as string
s = ""
If Commodity1=True then s = s + "Commodity1,"
If Commodity2=True then s = s + "Commodity2,"
...
If Commodity20=True then s = s + "Commodity20,"
s = Left(s,Len(s)-1))
Print s
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply