Search results

But why would the query work in SQL but not in Access? I guess it's something related to how Access reads the database.

It's exactly this. The criteria is being ignored altogether.

You're correct. I've tried various joins to no avail. On the Access side, the field is listed as a short text field. In the actual SQL database, it's listed as a varchar(50),not null) format. The data types are the same as I can tell.

Sorry for the delay folks. Here's the SQL Query: SELECT ENCOUNTER.MRNTreatHospitalAbbreviation, FINANCIALTRANSACTION.ServiceDate, FINANCIALTRANSACTION.PostingDateFormat, FINANCIALTRANSACTION.ActivityCode, FINANCIALTRANSACTION.ActivityCodeDescription, FINANCIALTRANSACTION.CPTCode...

Oh sorry. I misunderstood. I thought you were asking for the results. I'd have to ask the DBA to provide it to me. I don't have SQL. Just access to the data warehouse.

So I removed all links and just tried to search against the transactional data alone. I was still getting the same unfiltered revenue codes.

Unfortunately I'm not able to share any of the data. It's PHI so I'm limited in what I can provide. We're fairly puzzled on our end as well. And again, the stranger part is that running a direct SQL query yields the correct results.

Still got all of the rev codes. :(

Correct. I get all of the available codes and their relevant data in the query. Only when I Make Table, do I actually get the filtered data. Posting date is a date field. I adjusted the date field and it is working. It's only the revenue code that isn't being filtered appropriately.

He was able to run the query against the SQL database directly using the virtually the same SQL code I had in Access and did so successfully. When I used the Make Table button using my existing query it worked with no problems. It's only happening when I run the query directly. Here's the...

I'm not getting any errors. It pulls in all of the data. When I apply a filter in the design view it pulls in all of the data as if I have not applied a filter. The field is actually listed as a Short Text field but the content is numeric. I spoke with our DBA and he's thinking that this is...

I'm pulling data off of a SQL server through an ODBC connection. My query is pulling in various transactional data for a hospital. All of the data comes out successfully in the query. I was also able to apply a filter by date. The issue I run into is trying to apply a filter based on a specific...