I am trying to run a form that has a DBGrid on it which I would like to populate with a Transform statement in order to capture a crosstab query. My query works fine in Access, but I don't know how to get it to populate a dbgrid in VB. I changed the syntax to normal SQL rather than Access SQL and it still doesn't work. Please help me.
