Using Checkbox to generate open dollar amount

[Guest]

I would like to know if there is a way in a purchase order database to design
a checkbox (per line item) that, if selected (which means line item has been
received) wiill subtract that line items total from the total value of the
purchase order. I'm sure this can be done, but do not have the proficiency
in access to accomplish this task. Any help is greatly appreciated. Thanks.

 

[Douglas J Steele]

Add a boolean field to your table, something like PaymentReceivedFG.

To determine the total of the purchase order less those items, you'd look
for only those rows with PaymentReceivedFG = False. To get the total of the
received items, you'd look at only those rows with PaymentReceivedFG = True.

 

[Guest]

I understand the logic, but am having trouble witht he actual code. Would
you please write a sample statement. Thanks.

 

[Douglas J Steele]

Sorry, you haven't given nearly enough information.

 

[Guest]

Mr. Steele, may I e-mail you?
--
RSF

Sorry, you haven't given nearly enough information.

 

[Douglas J. Steele]

Sorry, no. The fact that I answer questions in the newsgroup should not be
taken as an implication that I'm willing to answer questions via private
e-mail.

I believe in newsgroups. Sending private e-mail, to my mind, defeats the
purpose of the newsgroups. First, it's of less benefit to you, since now
you're tied to me having to check my e-mail, find time to reply, etc.,
whereas if you post to the newsgroup, someone else may be able to answer
your question instead of me. As well, if you have a particular problem, odds
are someone else out there has the same problem, and they won't benefit from
private e-mails. Remember, too, that everything posted to the newsgroups
gets archived at services such as
http://groups.google.com/advanced_group_search , so others can benefit for a
long time (and perhaps I won't have to answer the question again <g>).

Post more details about what how your application is set up, and I (or
someone else) will hopefully be able to help you. It would probably be a
good idea to start a new post, so that other people don't think the problem
has already been solved.