Search results for query: *

I'm sorry I meant in the query it will not associate the serial # with a name instead it makes a new entry with that serial and no name. The same serial # still shows with the name but none of the new transactions are added to it. I need to get the name associated with the # in the query...

Name is in both of my tables and they are both part of the query with a relationship from a Serial# that is a primary key to another serial#

I am having trouble with a query. I have a set of serial #'s, which in a form associate with a name from another table. But in the query it won't associate with that name. I can eneter the data into a table with the serial# and the name showing but when I go back into the query, only the serial...

I'm trying to set up a charge account system for our customers using access. I have set up two tables one with customer info the other with transaction info. I also set up a query to calculate the sums for each customers Transactions and Payments. Then I set up a form to calculate the balance...

Tmconsult-I am trying to set up the form so that the transactions and payments will be entered in the form and then the correct balance will be updated. Your method looked like it was going to work fine, I just don't understand why it wouldn't let me enter new data afterwards.

gol4- This is what it said, I thought I got rid fot that error but then it wouldn't allow to open the query because of the same problem SELECT Customers.[Serial#], Transactions.Name, Sum([Payment]) AS sumpayments, Sum([Transaction]) AS sumtransactions FROM Customers INNER JOIN Transactions ON...

gol4-I have never used a query before and I am not having much luck following your directions. I keep getting an error concerning the customer id that says I didn't include the specified function as part of an aggregate function. I have no idea what to do.

Tmconsult- I tried to do what you told me to and it worked fine, however now back in the form it will not let me enter any type of data in new record and keeps repeating the original transaction. Do you have any more help for me ?

gol4-I tried that formula but it is not working for me. I am using information from 2 to three different tables and I'm not sure if that affects the formula.In addition to getting the correct balance I also need to get the customer Id to associate with a specific name. I have that working but I...

Thanks guys I'll give that a try and hopefully it'll work.

I am just starting with Access97. I would like to set up a form that allows me to enter a transaction (currency) for a customer and then display a correct balance for that customer. I have two tables one with "Customer ID" "Name" "Address" and then another table...

I'm working in a form trying to set up an expression that calculates the Balance from the payment and transactions. I can only get it to do the total balance for all transactions and payments or it does the balance just for the last transaction. What I need to know is how to get the balance per...