Received: from smtp2.dnb.com (smtp2.dnb.com [204.254.175.103]) by hub.org (8.10.1/8.10.1) with ESMTP id e5TLlx107603 for ; Thu, 29 Jun 2000 17:47:59 -0400 (EDT) Received: from relay.us.dnb.com (relay.us.dnb.com [159.137.225.58]) by smtp2.dnb.com (8.9.3/8.9.3) with ESMTP id RAA12018 for ; Thu, 29 Jun 2000 17:47:40 -0400 (EDT) Received: from smtp-gw.us.dnb.com (smtp-gw.us.dnb.com [159.137.225.51]) by relay.us.dnb.com (8.9.3/8.9.3) with SMTP id RAA10098 for ; Thu, 29 Jun 2000 17:47:31 -0400 (EDT) Received: from 159.137.224.39 by smtp-gw.us.dnb.com with ESMTP ( WorldSecure Server SMTP Relay(WSS) v4.0.2); Thu, 29 Jun 00 17:42:34 -0400 X-Server-Uuid: 512bef52-27db-11d3-8937-0008c7cf307c Received: by exbhbhbh02.us.dbisna.com with Internet Mail Service ( 5.5.2650.21) id ; Thu, 29 Jun 2000 17:47:29 -0400 From: "Schlobohm, Jack" To: "'pgsql-sql@postgresql.org'" Subject: error 3122 in ACCESS - Date: Thu, 29 Jun 2000 17:33:19 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) X-WSS-ID: 15451D40256749-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <15451D40256749-01@WorldSecure_Server__smtp-gw.us.dnb.com_> X-Archive-Number: 200007/6 I have a query which uses an expression... dividing "1" by a number field in a static table. I changed the expression to divide by a different number field from the same table. This caused an error. Error 3122: I tried to execute a query that doesn't include the specific expression < * > as part of an aggregate function. The possible cause is listed as: I didn't enter an aggregate function in the TRANSFORM statement. OK - The only thing different from this query and the one that worked is which field is included in the expression. The expression is { NewFieldName: (1/[FieldName])*([FieldCreatedbyanEarlierExpressioninQuery]) }. 1st - What is a transform statement? 2nd- What is an aggregate function? 3rd - Would I need to change anything is SQL... and what? 4th- Why wouldn't the same expression work with a different field? Jack Schlobohm