Link to home
Start Free TrialLog in
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.
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can also directly edit SQL:
User generated image
Avatar of BPofMaple
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.
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.