Recent content by Maria_82

Hi thanks, I tried file on another pc at work & still same results, unfortunately. I also downloaded the database you sent me on your previous post and updated the subquery Balance field and obtained the attached (screenshot2) balances, which although show on every record, they don't seem...

Thanks ... unfortunately same results here! I'll try it on a different pc tomorrow! Thanks again!

Hi plog! Thanks for your snapshot - unlike mine, yours sure looks right. I'm not sure what's causing our queries to differ-maybe some setting in access? Could you send me the database to see whether I get the same results, please? Thanks for your time & help- appreciate! :)

I attached a snapshot of what my subquery is showing. Is it the same as yours?

I need a daily balance query on each account, but it only worked well for AccID 1 & 2 on sub-DailyTotals. For some reason, AccID 3 has no daily balance results on sub-DailyTotals. I used QTrans as the main query you advised above.

Thanks for reply & code. I have changed Debit & Credit to Amount as advised and created a sub directory with the sql you proposed. I'm not sure whether I did everything correctly, but the results aren't quite there. I have attached an updated file for your perusal. Thanks again.... p.s. If as...

You're correct on all three points above. I calculated the Balance, Days and Interest fields manually - and didn't notice mistakes! my bad! I hoped a database would help set a clear picture, but indeed it didn't! I'll try to explain my requirements better - I need to calculate the end balance...

1. You're right, I can replace the Debit & Credit fields with Amount. AccID can also be left out from TTrans. TrAccNo in TTrans, however is required to associate each transaction to an account number. 2. With regards to the transactions dated 08/11/2014, Days are not calculated as there aren't...

I have 3 Tables – One named TClients, another TAccounts and another TTrans (Transactions). The TTrans (Transactions) table consists of the following fields: TrID (AutoNumber), AccID (Reference to Account Number in TAccounts Table), Int = Interest Rate (percentage), TrDate (Transaction date)...

Greetings to ALL, I'm Maria & learning my way through Access after masteing Excel. I look forward to receiving your assistance in my queries and hope I could be of any help in any way to others!