Gossamer Forum
Home : Products : DBMan : Customization :

Calculating

Quote Reply
Calculating
Hi,

I read through some posts but I'm a little unclear on how to bring things together for what I need done.

I have a database that would look like this:
Userid Field1 Value1
xyz item1 100
xyz item1 100
xyz item2 200
abc item1 100
cdf item2 200
cdf item2 200
cdf item3 300

I need to display to only the owner of the record the following info when they call for it:
item1 = ______
item2 = ______
item3 = ______
total = ______

So for my example:
xyz would display to themselves:
item1 = 200
item2 = 200
item3 = 0
total = 400

abc would display to themselves:
item1 = 100
item2 = 0
item3 = 0
total = 100

cdf would display to themselves:
item1 = 0
item2 = 400
item3 = 300
total = 700

This information does not need to be written back to the database, only displayed when called for.

Does this make any sense?

Thanks in advance!
Adam

Subject Author Views Date
Thread Calculating anr 6251 Jul 22, 2000, 10:48 AM
Thread Re: Calculating
Ulic 6173 Jul 22, 2000, 9:29 PM
Thread Re: Calculating
LoisC 6153 Jul 23, 2000, 1:49 AM
Thread Re: Calculating
anr 6123 Jul 23, 2000, 6:11 PM
Thread Re: Calculating
LoisC 6105 Jul 24, 2000, 8:23 AM
Thread Re: Calculating
Ulic 6073 Jul 24, 2000, 8:26 PM
Post Re: Calculating
LoisC 6059 Jul 25, 2000, 2:57 AM
Thread Re: Calculating
anr 6079 Jul 27, 2000, 10:09 AM
Thread Re: Calculating
JPDeni 6029 Jul 27, 2000, 3:43 PM
Thread Re: Calculating
anr 6041 Jul 27, 2000, 4:15 PM
Thread Re: Calculating
JPDeni 6095 Jul 27, 2000, 4:21 PM
Thread Re: Calculating
anr 6055 Jul 27, 2000, 5:16 PM
Thread Re: Calculating
JPDeni 6046 Jul 27, 2000, 5:29 PM
Thread Re: Calculating
anr 6027 Jul 27, 2000, 5:57 PM
Thread Re: Calculating
JPDeni 6012 Jul 27, 2000, 10:08 PM
Thread Re: Calculating
anr 6015 Jul 27, 2000, 10:16 PM
Thread Re: Calculating
JPDeni 6011 Jul 27, 2000, 10:29 PM
Thread Re: Calculating
anr 6016 Jul 27, 2000, 10:34 PM
Thread Re: Calculating
JPDeni 6017 Jul 27, 2000, 10:42 PM
Thread Re: Calculating
anr 6039 Jul 27, 2000, 10:51 PM
Thread Re: Calculating
anr 6025 Jul 27, 2000, 11:02 PM
Thread Re: Calculating
anr 6005 Jul 27, 2000, 11:39 PM
Thread Re: Calculating
anr 1564 Jul 28, 2000, 1:10 AM
Post Re: Calculating
JPDeni 1567 Jul 28, 2000, 1:57 AM
Thread Re: Calculating
JPDeni 1569 Jul 28, 2000, 5:57 AM
Thread Re: Calculating
anr 1511 Jul 28, 2000, 12:25 PM
Post Re: Calculating
JPDeni 1513 Jul 28, 2000, 4:16 PM
Thread Re: Calculating
JPDeni 6043 Jul 27, 2000, 11:02 PM
Thread Re: Calculating
anr 6036 Jul 27, 2000, 11:04 PM
Post Re: Calculating
anr 6024 Jul 27, 2000, 11:06 PM