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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
need help with query
i have a table which shows customers oustanding, out of 500 customer if 3
pays me half the payment the part payment is yet to be received how can i show that outstanding? -- Nisha P |
#2
|
|||
|
|||
need help with query
On Sun, 20 Jul 2008 18:01:05 -0700, nishkrish
wrote: i have a table which shows customers oustanding, out of 500 customer if 3 pays me half the payment the part payment is yet to be received how can i show that outstanding? You're assuming that we have knowledge that we lack about the structure of your table and your business rules. What makes a customer "outstanding"? How are you storing customers, and payments? YOU can see your computer. We cannot. Please give us a bit of help here! -- John W. Vinson/MVP |
#3
|
|||
|
|||
need help with query
Sorry about that
i havent created a proper format for my table not yet able to figure out my database i have an excel file that i have imported and trying to work on it tabelTable contains following columns Transaction No.12345 Send Date:7/18/08 Sender : XXYYZZ Amount:$350 RecevingCountry:GBP 150 Charges:$15(there is formula which calculates charges automically once amount is inputed) Buy Rate SellRate Bank Deposit Agent Commission AgentID PaymentMdoe: cash/check/card Payment Received/outstanding Deposit Date I hope this will give clear picture of my table -- Nisha P "John W. Vinson/MVP" wrote: On Sun, 20 Jul 2008 18:01:05 -0700, nishkrish wrote: i have a table which shows customers oustanding, out of 500 customer if 3 pays me half the payment the part payment is yet to be received how can i show that outstanding? You're assuming that we have knowledge that we lack about the structure of your table and your business rules. What makes a customer "outstanding"? How are you storing customers, and payments? YOU can see your computer. We cannot. Please give us a bit of help here! -- John W. Vinson/MVP |
#4
|
|||
|
|||
need help with query
On Sun, 20 Jul 2008 19:01:00 -0700, nishkrish
wrote: Sorry about that i havent created a proper format for my table not yet able to figure out my database i have an excel file that i have imported and trying to work on it tabelTable contains following columns Transaction No.12345 Send Date:7/18/08 Sender : XXYYZZ Amount:$350 RecevingCountry:GBP 150 Charges:$15(there is formula which calculates charges automically once amount is inputed) Buy Rate SellRate Bank Deposit Agent Commission AgentID PaymentMdoe: cash/check/card Payment Received/outstanding Deposit Date I hope this will give clear picture of my table well... sorry. You don't have a table. You have a spreadsheet copied into Access. You ask: "out of 500 customer if 3 3 what? Three of the customers? What does the 3 refer to? pays me half the payment How can Access (or anyone) tell whether a payment is full or part or half or what? What is the datatype and contents of the "payment" field? How is it filled? the part payment is yet to be received how can i show that outstanding? Do you want to change the value of the Payment field? If so the field *should simply not exist* in your table; calculate it instead. I fear you're applying spreadsheet thinking to a database. A database is NOT a spreadsheet and requires a different structure and different logic! Do read up about database design and normalization before you go too much further with this. See http://www.mvps.org/access http://www.accessjunkie.com for some references. -- John W. Vinson/MVP |
Thread Tools | |
Display Modes | |
|
|