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

Microsoft Query Calculated Field

I am trying to create a calculated field in Microsoft Query.

Pallets: Qty/Pal_Amnt

Returns - Syntax Error.

Qty/Pal_Amnt

Returns - Too few parameters. Expected 1.

???

Also, when I "Return Data to Microsoft Excel", I get a different layout.
0
BPofMaple
Asked:
BPofMaple
  • 2
  • 2
1 Solution
 
als315Commented:
You can't assign column header in MS Query this way. Set calculated value to Qty/Pal_Amnt, doube click on it and add Title:MS Query
0
 
als315Commented:
You can also directly edit SQL:
MS Query
0
 
BPofMapleAuthor Commented:
Thank you.  Both ways presented work and I used the SQL method to change SUM to COUNT which gave me the result I wanted. I am so glad to have experts-exchange at my disposal since the 'experts' I work with have no idea how to help me. Even instructors at a local computer training school can't help. If the problem isn't in their workbook, forget it.
Thanks again.
0
 
BPofMapleAuthor Commented:
While Qty/PalAmnt originally returned an error message, I switched computers and the equation worked somewhat magically. Now I understand that Excel doesn't always perform as it should.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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