Solved

Microsoft Query Calculated Field

Posted on 2013-01-06
4
451 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
  • 2
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 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 39

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
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…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

770 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