Need help in Query

[Altaful Haq]

As there is any posibilities that we can write the query like
"Match the field X of a form with the X field of the table with the last records of one Customer having multiple records."
Help pleas.

[June7]

You want to find a value from the most recent record for a specific customer? Yes, that can be done. It is tricky but possible. Need more info. Provide example of table structure and data.

[Altaful Haq]

CustomerID(FK) BalanceID(PK) Oldbalance NewBalance NetBalance Payment RemainBalance
...........1........ .......1.......... .....50$..... .....100$.... ......150$... ..140$.. ........10$.....
...........1........ .......2.......... .....10$..... .....50$.... ........60$... ..60$.. ........0$.....

[June7]

You are saving balances into table? Saving calculated data, especially aggregate data, is usually a bad idea.

Here is one way to get the value from another record http://allenbrowne.com/subquery-01.html#AnotherRecord

You want running balance. That is not easy in query or form. Common topic.

http://support.microsoft.com/kb/290136