Search results for query: *

Geoff, Thanks for the reply. Unfortunately, for some very strange reason the above doesn't work. I agree, what you've got sounds correct, and with the 'Excel.Application' object it does, but not with OWC (Office Web Component). Might be a bug in the component, or there might be a more obtuse...

I'm not sure how many people use the OWC for spreadsheets, but I've had an impossible time tracking down much documentation. What I do have working has been very successful and does the job really well, but it's incredibly frustrating to figure out all the OWC features. Currently I'm trying to...

That did the trick. Can't thank you enough! Yeah, I guess my ON clause may have been a bit non-standard, though it certainly gave me what I wanted (when I moved the 'tblB=#' statement into the WHERE clause it basically acted as an inner join instead). I guess Access can be exciting that way...

I've got a pretty straight forward LEFT OUTER JOIN going, grabbing data from the left side table and getting either matching data from the right or null values. That's the plan anyway, and on my dev machine it works great. But on my live site the query only returns values if the right-hand table...