Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bryand

    Help With Forms and Queries

    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...
  2. bryand

    Query Trouble

    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#
  3. bryand

    Query Trouble

    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...
  4. bryand

    Help With Forms and Queries

    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...
  5. bryand

    HELP WITH EXPRESSION BUILDER

    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.
  6. bryand

    HELP WITH EXPRESSION BUILDER

    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...
  7. bryand

    HELP WITH EXPRESSION BUILDER

    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.
  8. bryand

    HELP WITH EXPRESSION BUILDER

    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 ?
  9. bryand

    HELP WITH EXPRESSION BUILDER

    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...
  10. bryand

    HELP WITH EXPRESSION BUILDER

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

    HELP WITH EXPRESSION BUILDER

    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...
  12. bryand

    Expressions

    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...

Part and Inventory Search

Back
Top