Is this a Querie or Sorting problem?

[bwrobel]

Select [Liner id #], [record number]
From [Liner A]
Group by max[date inspected]

Seem like it should work, but I getting "Error -2147217900: Syntax error (missing operator) in query expression 'max[date inspected]'."

Help me obi wan, your my only hope

 

[bwrobel]

SELECT [Liner ID #], Max([Date Inspected]) AS [MaxOfDate Inspected]
FROM [Liner A]
GROUP BY [Liner ID #];

I DID IT !!!!!!!!!!!!! If anyone had that problem you can use that format... now I'll go back to dancing in my office

 

[neileg]

Why don't you use the query grid and the wizards, rather than writing raw SQL? It's true that there are things you can't do in the grid that you have to resort to writing the SQL, but for simple stuff like this, the grid is quicker and easier.

Pleased you got there in the end!

 

[bwrobel]

The query grid was the key. Sometimes you have to step-back and try the most simple way.

I was just over-analyzed... sometimes you just got to take a break.