Search results

Hi, Thanks for replying with that formula. I tried to put this formula into my query and I received the following messages: You tried to execute a query that does not include the specified expression "Transaction#" as part of an aggregate function. So then I eliminated the "Transaction#"...

Hi, I have a form that allows you to enter deposits and/or withdrawals from petty cash. I am trying to figure out how to have a current balance show in the form based on past transactions as well as the current transaction. I would also like to be able to run a query that lists all of the...

Thanks so much for the link. It helped me out tremendously. I was able to get the field in my form to fill in automatically. Thanks again!

I am wondering if anyone has designed an access database for petty cash transactions, i.e. deposits, withdrawals, running balances, etc? If so, does anyone have a template for this or know where I can get one? Thanks, kmp

I am not sure if I understand exactly what it is that I need to do. Do I have to start over and design a new form or can I use the form that I have already designed? I set up a query like you said and started a new form based on the query. The acct description comes in automatically based on...

I have a form with a combo box that lists an acct # and acct description. When you select the account number in the form field, I would like the acct description to automatically fill in another field. I tried to use a dlookup function but I think there might be more that I need to do. Any...