need help with query

[nishkrish]

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?

 

[John W. Vinson/MVP]

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!

 

[nishkrish]

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

 

[John W. Vinson/MVP]

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.