?
Solved

Microsoft Query Calculated Field

Posted on 2013-01-06
4
Medium Priority
?
455 Views
Last Modified: 2013-01-24
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
Comment
Question by:BPofMaple
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 2000 total points
ID: 38748334
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
 
LVL 40

Expert Comment

by:als315
ID: 38748342
You can also directly edit SQL:
MS Query
0
 

Author Comment

by:BPofMaple
ID: 38814635
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
 

Author Closing Comment

by:BPofMaple
ID: 38815404
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

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question