Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • 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
submarinerssbn731
Asked:
submarinerssbn731
  • 4
  • 3
  • 2
2 Solutions
 
Vadim RappCommented:
there must be a dot between table and field name.

3600/ BOM.[STD_CYCLE] * BOM.[CAVITIES]
0
 
submarinerssbn731Author 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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
submarinerssbn731Author Commented:
It is not a SQL query statement but an Access 2003 query in design view.
0
 
submarinerssbn731Author 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
 
submarinerssbn731Author 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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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