A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

deduct order quantity from credit limit



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2010, 02:32 PM posted to microsoft.public.access.queries
klp via AccessMonster.com
external usenet poster
 
Posts: 98
Default deduct order quantity from credit limit

I have on my customer master, a field for credit limit. The user can input
the credit limit for that particular customer. When the user then goes in to
the order screen, in the line item section, I would like for an message to
come up if they have reached their credit limit. So I know I would have to
compare the order quantity against the credit limit. Would I do this in a
query? Do I need to create a different type of query instead of a standard
one? So I would want to see:

Customer Credit Limit Qty Ordered Amt Avail
ACE Hardware 650 20
630
ACE Hardware 60
570

And have it keep it going for every order. Is this possible? What is the
easiest way to do this?

Thanks in advance
Kim P

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201006/1

  #2  
Old June 2nd, 2010, 03:36 PM posted to microsoft.public.access.queries
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default deduct order quantity from credit limit

You need to have customer and their credit limit in one table and their
ordering and payments (transactions) in another.
You have to keep a running balance or otherwise you would not let them order
more even though they have paid the bills.
A query would sum their transactions and real-time reduce their credit limit
as of that date by the total outstanding balance.

--
Build a little, test a little.


"klp via AccessMonster.com" wrote:

I have on my customer master, a field for credit limit. The user can input
the credit limit for that particular customer. When the user then goes in to
the order screen, in the line item section, I would like for an message to
come up if they have reached their credit limit. So I know I would have to
compare the order quantity against the credit limit. Would I do this in a
query? Do I need to create a different type of query instead of a standard
one? So I would want to see:

Customer Credit Limit Qty Ordered Amt Avail
ACE Hardware 650 20
630
ACE Hardware 60
570

And have it keep it going for every order. Is this possible? What is the
easiest way to do this?

Thanks in advance
Kim P

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201006/1

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.