Avatar of BPofMaple
BPofMaple
 asked on

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.
Microsoft Excel

Avatar of undefined
Last Comment
BPofMaple

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
als315

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
als315

You can also directly edit SQL:
MS Query
BPofMaple

ASKER
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.
BPofMaple

ASKER
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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck