• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

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]
0
Steve Eckerman
Asked:
Steve Eckerman
  • 4
  • 3
  • 2
2 Solutions
 
Vadim RappCommented:
there must be a dot between table and field name.

3600/ BOM.[STD_CYCLE] * BOM.[CAVITIES]
0
 
Steve EckermanSystems AdministratorAuthor Commented:
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.
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Is the table BOM included in the From clause of the SQL? Or put another way. have you added the table BOM to the query?

Note: Not adding ( and ) the calculation will be the same as:

(3600 / BOM.[STD_CYCLE]) * BOM.[CAVITIES] 

Open in new window


Is that what you want?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Steve EckermanSystems AdministratorAuthor Commented:
It is not a SQL query statement but an Access 2003 query in design view.
0
 
Steve EckermanSystems AdministratorAuthor Commented:
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!!!
0
 
Vadim RappCommented:
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.
0
 
Vadim RappCommented:
The initial problem was resolved by comment ID: 39715011
0
 
Steve EckermanSystems AdministratorAuthor Commented:
Great answers!!!   Thanks!!!
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now