Search results

So it appears that this query can't resolve the last variable of [TempVars]![SortOrderBy] but if I were to change that to just WorkOrder for example, it works fine. SELECT ticketqueue.ID, ticketqueue.WorkOrder, ticketqueue.Details, ticketstatus.StatusName, ticketpriority.PriorityName...

Hi all. First post here. Super new to messing around with VBA but have gotten pretty far I think. Here's the problem. I have a variable that contains a perfectly acceptable MySQL statement (as in, I can copy it into mysql directly and it works) yet when I run it through CurrentDb.Execute...