You tried to execute a query that does not include the specified expression as part of an aggregate

[irethedo]

I am getting the following message when I run this query:
You tried to execute a query that does not include the specified expression 'Date' as part of an aggregate function

SELECT A.Date, A.Cust_Name, A.SO_No, (select count(*) from SPnoteOrder_tbl as B where B.LineNO < A.LineNO and A.ComputerName = b.computerName)+1 AS Rank, A.ComputerName, A.FriendlyName, A.License_PartNo, A.Part_No, A.System, A.NW_Ver, A.Country INTO Order_tbl
FROM SPnoteOrder_tbl AS A
GROUP BY A.NW_Ver;

What am I missing?

thanks

 

[Andrzejek]

Just a guess here, but Date is a reserved word in Access (that should be avoided).
Try
[tt]SELECT A.[Date], A.Cust_Name, ...[/tt]
or rename your field Date to something else.

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[irethedo]

I renamed it to Date1 both in the query and the table and still get the same
error with the new name of the field...

You tried to execute a query that does not include the specified expression 'Date1' as part of an aggregate function

 

[irethedo]

It didn't like the GROUP BY A.NW_Ver;

 

[Andrzejek]

Usually you use GROUP BY if you do aggregate query, but in your example you do not do that. The only aggregate is in the inner SELECT which you don't need to do Group by.
Try to eliminate the GROUP BY part and see if you get what you want.

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[kray4660]

I suspect that grouping is not allowed when doing a INTO.