Results 1 to 2 of 2

Thread: Access Query

  1. #1
    Join Date
    Feb 2005

    Unanswered: Access Query

    I'm trying to write an access query that sums up a certain field in a table where it matches a field in another table but i get the error that i tried to execute a query that does not include the specified expression "PartsCosts" as part of an aggregate expression. I found that i need a group by clause but when i try to add the group by clause, i get an error that i'm missing a ;, even though i have it. here is the query in sql view.

    UPDATE PartsUsedTable INNER JOIN RepairRecords ON PartsUsedTable.RepairNumber = RepairRecords.RepairNumber SET RepairRecords.PartsCosts = Sum([PartsUsedTable].[ExtendedCost]) WHERE [RepairRecords].[RepairNumber]=[PartsUsedTable].[RepairNumber];

    any one have a clue?


  2. #2
    Join Date
    Feb 2004
    How about:
    UPDATE RepairRecords 
    SET RepairRecords.PartsCosts = 
    & [RepairNumber] & "'");
    See if this works for you.

Posting Permissions

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