Getting a pop-up as Query1.MyDate

[BizBoy]

Hi,

I am using below query to get details from database.

SELECT Designation, MyDate, Count(Designation) AS MyCount
FROM Combine
WHERE Designation = 'Senior Dummy Manager'
GROUP BY Designation, MyDate
ORDER BY Count(MyDate);

However, whenever I click on query, I get a pop-up as Query.MyDate.
Once I click ok, I get the results. But I am not able to understand why I am getting this pop-up.
Can anyone please help me in this.

 

[xenou]

Usually this means you have misspelled a field. For instance, it might be [My Date] or [My_Date] instead of [MyDate]. In other words, Access is treating something in the query as a field that needs user input.

 

[BizBoy]

Thanks for the help xenou.

I re-checked my query. But could not find spelling mistake.

Below is my query.

SELECT Program, MyDate, Count(Program) AS MyCount
FROM Combine
WHERE Program = 'MET'
GROUP BY Program, MyDate
ORDER BY Count(MyDate);

And 'MyDate' field name copied from database.
Also, once I click OK on pop-up I am getting correct results.

I am not sure, but if I have wrong spelling, will I still get correct results ?

Please do not think I am being arrogant. Just trying to clear my doubt.
Have a nice day ahead.

 

[xenou]

THe diagnosis is still the same. Access is trying to get user input ( a parameter ).
https://www.universalclass.com/articles/computers/parameter-queries-in-microsoft-access-2013.htm

 

[BizBoy]

Thanks for the help xenou. Have a nice day ahead.

 

[james_lankford]

ORDER BY Count(MyDate);

can you do that ?

shouldn't it be
ORDER BY Count(Program)

 

[xenou]

Good catch. That is probably an issue (whatever is in the order by should be the same as what is in the select).

 

[BizBoy]

Hi James,

Thanks a lot for the help. Have a nice day ahead.