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
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
