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 6546 Jul 22, 2000, 10:48 AM
Thread Re: Calculating
Ulic 6462 Jul 22, 2000, 9:29 PM
Thread Re: Calculating
LoisC 6442 Jul 23, 2000, 1:49 AM
Thread Re: Calculating
anr 6412 Jul 23, 2000, 6:11 PM
Thread Re: Calculating
LoisC 6394 Jul 24, 2000, 8:23 AM
Thread Re: Calculating
Ulic 6362 Jul 24, 2000, 8:26 PM
Post Re: Calculating
LoisC 6348 Jul 25, 2000, 2:57 AM
Thread Re: Calculating
anr 6368 Jul 27, 2000, 10:09 AM
Thread Re: Calculating
JPDeni 6318 Jul 27, 2000, 3:43 PM
Thread Re: Calculating
anr 6330 Jul 27, 2000, 4:15 PM
Thread Re: Calculating
JPDeni 6384 Jul 27, 2000, 4:21 PM
Thread Re: Calculating
anr 6344 Jul 27, 2000, 5:16 PM
Thread Re: Calculating
JPDeni 6335 Jul 27, 2000, 5:29 PM
Thread Re: Calculating
anr 6316 Jul 27, 2000, 5:57 PM
Thread Re: Calculating
JPDeni 6301 Jul 27, 2000, 10:08 PM
Thread Re: Calculating
anr 6304 Jul 27, 2000, 10:16 PM
Thread Re: Calculating
JPDeni 6300 Jul 27, 2000, 10:29 PM
Thread Re: Calculating
anr 6305 Jul 27, 2000, 10:34 PM
Thread Re: Calculating
JPDeni 6306 Jul 27, 2000, 10:42 PM
Thread Re: Calculating
anr 6329 Jul 27, 2000, 10:51 PM
Thread Re: Calculating
anr 6314 Jul 27, 2000, 11:02 PM
Thread Re: Calculating
anr 6294 Jul 27, 2000, 11:39 PM
Thread Re: Calculating
anr 1645 Jul 28, 2000, 1:10 AM
Post Re: Calculating
JPDeni 1648 Jul 28, 2000, 1:57 AM
Thread Re: Calculating
JPDeni 1650 Jul 28, 2000, 5:57 AM
Thread Re: Calculating
anr 1592 Jul 28, 2000, 12:25 PM
Post Re: Calculating
JPDeni 1594 Jul 28, 2000, 4:16 PM
Thread Re: Calculating
JPDeni 6332 Jul 27, 2000, 11:02 PM
Thread Re: Calculating
anr 6325 Jul 27, 2000, 11:04 PM
Post Re: Calculating
anr 6313 Jul 27, 2000, 11:06 PM