Recent content by ewart

Thanks I wiil try that

I have a database with these headers: account, sbu, agn and amounts. The amount column consist of both debits and credits. The reason I wanted to create a new column is so I can run a query to match debits and credits with these criteria's, same account #/ same sbu#/ same agn #.

How to create a second amount column in access? Thanks

Hi, The post named query help was incorrectly stated. I have a table called leg-detail, this table was converted from text in access. In this table I have accounts, sbu's, agreement #'s amount (dr/cr). I would like to create a query that will give me all the record that match. A match...

Hi guys, i'm a rookie when it comes to access. My delima is my boss need someone to run some queries for him and since no one has any knowledge of access I was given the responsibility of meeting his needs. What he wants sound simple however as I mention earlier i'm a rookie at this. We have a...

Hi Guru's, I need help with a query that i'm running. From join properties option when linking two table, how can I find the remainding records that are not equal to the joint fields?

Thank you kindly.

Sorry for not explaining myself entirely, my true problem is trying to suppress the two decimals places in a query.

Does anyone knows what are the operator in access for rounding cents.

I'm trying to create a query where as it would bring back matching debits/credits amounts.