MS Query Error Help - Using Parameters

alan2624

New Member
Joined
Aug 28, 2014
Messages
2
I am using MS Query in Excel and the query runs fine. It has parameters and is detail records.

When I change the number column to be a summary instead of details, I get errors saying the:

Invalid column name 'period'.
Statement(s) could not be prepared.

'Period' is the name of the parameter that worked fine until I tried to summarize the amounts.

FYI - unfortunately I am hooking up to an SQL 2005 DB.

Thank you
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,099,029
Messages
5,466,116
Members
406,467
Latest member
bpat83

This Week's Hot Topics

Top