Results 1 to 2 of 2

Thread: Update Query

  1. #1
    Join Date
    Jan 2010
    Posts
    10

    Unanswered: Update Query

    Hi,
    I have a invoice report which has multiple orderID`s and when this is invoiced i would like the invoiced tick box to be updated with all the OrderID on the invoice. How can this be done? The invoice is generated by a parameter query by date. So basically i am looking to use the results from the parameter query to update the tblorders table.

    Help??

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    You can make the query a make-table query to make a 'temporary' type table and then use that table to link back into a query which updates the field, or you can use the query itself and link it within another query to update the data (depending on the complexity of the query).
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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