Link to home
Start Free TrialLog in
Avatar of Steve Eckerman
Steve Eckerman

asked on

Access 2003 expression

Below is the expression I am trying to use in a query however when I try to save the query it says I have entered an operand before an operator.  The BOM is the table the two fields are in brackets.  Any ideas???  Thanks



Expr1: 3600/ BOM [STD_CYCLE] * BOM [CAVITIES]
SOLUTION
Avatar of Vadim Rapp
Vadim Rapp
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve Eckerman
Steve Eckerman

ASKER

I put the dots in and then it removes the brackets and then gives me an error stating you tried to execute a query that does not include the specified expression '3600/BOM.STD_CYCLE*BOM.CAVITIES as part of an aggregate function.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It is not a SQL query statement but an Access 2003 query in design view.
I've requested that this question be closed as follows:

Accepted answer: 0 points for submarinerssbn731's comment #a39715105

for the following reason:

Finally got it to run!  Thanks so much!  Excellent Expert!!!
That it does not include the expression as part of an aggregate function is different problem. If your query has GROUP BY, every expression has to be either in aggregate, or in GROUP BY. For more information, search the web for "does not include as aggregate function", or post separate question.
The initial problem was resolved by comment ID: 39715011
Great answers!!!   Thanks!!!
It is not a SQL query statement but an Access 2003 query in design view.

FYI: The Access query designer is just a GUI view of the SQL statement you are creating. The Query Designer view is a great to. Note that not all possible SQL statement can be displayed in Design view. There are times when you must switch to SQL view and write the SQL statement manually.