Search results

And then I guess you'll be asking for the SQL of the other query, right? :P

The SQL for the other query is: SELECT ALL CourseYear, CourseMonth, BookingTDA, ClientTDM, ClientTDA, CTLAccountName, AC_Manager, SumOfOverallTotal,Type FROM qryTDAFigs_TrainingAllSum_C UNION ALL SELECT ALL CourseYear, CourseMonth, BookingTDA, ClientTDM, ClientTDA, CTLAccountName, AC_Manager...

Oh, sorry! Query SQL: SELECT qryTDAFigs_Export_C.CourseYear, qryTDAFigs_Export_C.CourseMonth, qryTDAFigs_Export_C.AC_Manager, qryTDAFigs_Export_C.CTLAccountName, qryTDAFigs_Export_C.BookingTDA, qryTDAFigs_Export_C.ClientTDA, qryTDAFigs_Export_C.ClientTDM, qryTDAFigs_Export_C.SumOfOverallTotal...

Hi guys, new member here. I hope I have posted this in the correct section! I've done a little bit of a search on the net and I can't seem to find an answer to this.. Basically we have a query here that works just fine when run through access. When we try to link it to excel however, it shows...