The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Solved
Microsoft Query Calculated Field
Posted on 2013-01-06
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.
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.
2-
2
4 Comments
Active 2 days ago
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:
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.
Thanks again.
Featured Post
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 Already a member? Login.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses
Course of the Month6 days, 5 hours left to enroll
569 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.