Thread: SQL select as

Using excel 2007 i'm trying to grab some data but my sql is erroring

rst.Open "Select (MAX([Subscriber %]) as pc, Platform as plt) from Package WHERE [ID] IN (" & Join(Application.Transpose(idt), ",") & ") and [Digital/Analogue] = 'Digital' and Operator = 'BSkyB' and Country = '" & cntry & "'", conn

i want to select max subs and platform as two different objects, this works with subs only but not with two!

thanks

Jonathan

My guess would be the array is the problem, as SQL will not understand that string. Maybe each element needs single quotes around them if they are strings.

The array idt?

this doesn't seem to be at fault, as when i remove the platform as plt the statement executes correctly..
i was thinking i must have the syntax for selecting multiple columns as xx must be off


thanks

Hmm ok.. well thanks guys i just created two separate statements that does the same, it's a bit messy, but does the job


thanks for your time

Jonathan

Hi,
yeah i had a go at group by but not much luck i'm afraid...

the suggestion of a book is not bad at all
i,m using vba in excel for a access db.. so i'll go check out Amazon methinks


thanks

Jonathan