Query works in Access, but not VB .NET
I'm a relatively new programmer, and I'm attempting to duplicate an Access query in to VB .NET. I expected this to be a simple copy/paste from Access, but that has not been the case. When I attempt to run the following query from Access, I get a ton of records. From VB .NET in a AccessDataSource control, I get nothing. Here's the query:
And here's the code (which has worked fine with other queries):
Any ideas would be greatly appreciated! I've burned 99% of my brain on this today. Thanks!