Macro query against a SqlServer database

**marizar** · 10-28-2012, 08:54 PM

I have an existing query that is run against a sqlserver database that returns production data for a group of machines. I need another query to find the timestamp of the latest record that each machine produced. How can I do that with msquery and not have to pull in multiple days of data and use excel functions?
Thanks

**alansidman** · 10-28-2012, 09:04 PM

Your query would look something like this:

Please Login or Register  to view this content.

Here is a quick explanation

http://www.w3schools.com/sql/sql_groupby.asp

**marizar** · 10-29-2012, 08:32 AM

Alan

Thanks for the help...........but I can't seem to get the syntax correct. Here is the vba for my existing query:

Please Login or Register  to view this content.

Then my latest effort at your code:

Please Login or Register  to view this content.

I get a sql syntax error.

Ron

**Kyle123** · 10-29-2012, 08:55 AM

Try executing the query against the database before trying to make it work with Excel, at least then you'll know the syntax is right

**JosephP** · 10-29-2012, 09:12 AM

shouldn't it be 'group by' instead of 'group on'?

**alansidman** · 10-29-2012, 10:19 AM

JosephP, thanks. You are correct. My Bad. Tough getting old and having moments like that.

Marizar, Kyle makes an excellent point. Make sure it works in the db first.

Alan