First Query
SELECT Year([MyDate]) AS YearfromDate
FROM TransactionTable;
Second Query
SELECT Query1.YearfromDate
FROM Query1
GROUP BY Query1.YearfromDate;
Why does this error appear
Invalid procedure call
When run query 2
and what is the solution
Thank you so much
SELECT Year([MyDate]) AS YearfromDate
FROM TransactionTable;
Second Query
SELECT Query1.YearfromDate
FROM Query1
GROUP BY Query1.YearfromDate;
Why does this error appear
Invalid procedure call
When run query 2
and what is the solution
Thank you so much