Results 1 to 3 of 3

Thread: Update queries

  1. #1
    Join Date
    Feb 2005
    Posts
    3

    Unanswered: Update queries

    I am having problems with update queries that lead to tables. These are connected with forms. The queries connected with these tables and forms are the update queries and normal queries.The queries work fine but its not updating from a query to a table.

    Any help please?

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    What are your queries can you post the SQL,
    how are you running your update query?
    without this information others are likely to be as clueless as me as to what you are actually doing and help you out
    Update queries work in the following format

    UPDATE tablename
    SET fieldname = Value

  3. #3
    Join Date
    Feb 2005
    Posts
    1

    An update from wananns update query problem

    My update query is to total all the net amounts for an ordering system. The nett amounts show up in a form and subform but not in the table. The formula I have put in the update query is:
    TblSalesOrderLine.[SalesItemNettAmount]

    TblSalesOrderLine is the table I want the data from the update query to go into and SalesItemNettAmount is the field in this table. Is this formula correct? And if so is there another reason why it's not working?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •