Simple Rank Expression Error

[DeVonn via AccessMonster.com]

The expression below keeps giving me a error messege "Reserved Error (-3025)
There is no message for this error"

Does any one have any suggestions.

SELECT Qry_weekly_Comparasion.date, Qry_weekly_Comparasion.day, (SELECT Count
(*) FROM Qry_weekly_Comparasion AS TMP WHERE
TMP.Date > Qry_weekly_Comparasion.Date AND TMP.Day = Qry_weekly_Comparasion.
Day)+1 AS Week;

 

[Sylvain Lafontaine]

Using date and day as field names could lead to some confusion with reserved
word in Access. Try replacing them or put them between []:

SELECT Qry_weekly_Comparasion.[date] as DateWeekly ...

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[DeVonn via AccessMonster.com]

Got it thanks.

The expression below keeps giving me a error messege "Reserved Error (-3025)
There is no message for this error"

Does any one have any suggestions.

SELECT Qry_weekly_Comparasion.date, Qry_weekly_Comparasion.day, (SELECT Count
(*) FROM Qry_weekly_Comparasion AS TMP WHERE
TMP.Date > Qry_weekly_Comparasion.Date AND TMP.Day = Qry_weekly_Comparasion.
Day)+1 AS Week;

 

[huangtianliang]

»ÆÌìÁÁ·¢²¼ÐÂÎÅ×éÐÅÏ¢
ÎÒ¸Õ¿ªÁ˸öСµê£¬µêÆ̵ÄÍøÖ·ÊÇhttp://shop57847548.taobao.com
»áÔ±ÃûÊÇ£º»ÆÌìÁÁ21
µêÃûÊÇ£ºÉê°ÂЬ³Ç-ÐË¡Ьµê
Çë´ó¼ÒÓÐʱ¼äÀ´¿´¿´°¡¡£µêÀïÖ÷Òª¾­Óª¸÷ÖÖ¿îʽµÄÄÐÅ®Ô˶¯Ð¬¡£¿îʽʱÉУ¬Ç°ÎÀ¡£