I have a table that has debits and credits in two different columns along with other info.

there is one debit for each credit. in some cases though there is one debit and 2 or more credits that sum up that ammount.

the common thing that Debits and Credits have is a project number in a seperate column.. but this alone will bring me all the entries!

how can i finf these lines? i have tried all sort of queries but nothing works.. anyone can help... its one thing i didnt think of..

thanks guys in advance...

If the project number has several debits and credits then that won't be an appropriate key. You need to somehow determine explicitly which credits belong to which Debits. For a record like this there would be no query that would separate them:
---------------------------------------
Project# Debit Credit
123 10.50 5.50
123 10.50 5.00
123 10.50 4.50
123 10.50 6.00
---------------------------------------

Implicitly we can determine there are two transactions here but without being able to determine this explicitly your code/database/form won't be able to differentiate between them. You need a field that will explicitly separate these in some way. Perhaps a date field, or a field that specifies an order number or invoice number that would be different between the two debits done for that project #. If you're sure the two debits will never be the same you COULD differentiate based on project number and the debit amount but this isn't a good assumption.