Search results

I think I got it. I adjusted the original query to pull from the new query and its doing what I needed it to do. Is that where you were going?

Ahhh. My mistake. Ok got it done. I created a new query and placed [Provider ID], [County], [State] & [Specialty]. I then changed properties for the query to Unique Values. The results look good so far. I see that the provider ID's are listed multiple time but are unique to each county, good start!

Ok in the original query ( I changed it from an append to a select query), also the grouping already makes it show the state and county only once. SELECT [DN11 TABLE (Access Points)].[Data Month], [DN11 TABLE (Access Points)].[Data Year], [DN11 TABLE (Access Points)].State, [DN11 TABLE (Access...

Maybe I did something incorrectly, but I tried that initially and it removed all additional provider id's regardless of whether the id was in a different county or not. Maybe I did something wrong?

Your example is almost what I am looking for. See attached. Perfect scenario would be that since this is a county search query, it would look at the Provider ID, County and State fields and make sure that the provider ID is only listed once per county. (also, the Provider ID field doesn't...

Thanks again! Attached is a sample of the table data. There are more fields but I can't share the data and since the query doesn't pull those fields it shouldn't matter. Let me know what you think! Msk7777

I have attached a sample of the current query results. The results I would like it to look like would be the same look but the values would be less since I need it to just pull unique values based off the [Provider ID] field. Sorry to be a pain and thanks for you continued assistance! Msk7777

I apologize but the link you sent me is about calculated values (my current query already calculates the values perfectly) and nothing I read on the page helps me. And you are correct, it does store them, but not in this database, it appends the results to another database where are stats are...

Thank you for responding! I apologize as I may not have made my need clear. The above query currently counts the different types of providers in the table by county. In the table the query is pulling from there is another field that has a provider ID number. This ID is unique to each...

Hello everyone, I have this query: INSERT INTO [DN11 (AP) County Counts] ( [Data Month], [Data Year], State, County, [General Dentist], Endodontist, Orthodontist, [Oral Surgeon], [Pediatric Dentist], Periodontist, Prosthodontist, [Total Providers] ) IN '\\cifs04\NetworkDevelopment\Provider...

Hello all, I have a table which has each claim as a single record. A client wishes us to provide the data in a format that lists the each procedure on its own line. I have attached a highlevel example of what the data currently looks like and what the query results should look like. So I...

pbaldy, Thank you so much! Your suggestion worked like a charm. Guess I was too close to the problem to think of such a simple, yet genius, solution. Thank you so much for your help! msk7777

pbaldy - Thank you so much for your quick response. That makes sense, however, I have no clue on how to go about applying your suggestions. This is why I was hoping for more of a walk-through. I am not going to ask anyone to stop their day and write one for me, I was just hoping someone knew...

Hello everyone, I have been searching this forum as well as several others for a solution to my problem. I have always used parameter forms for inputing query/report criteria. However, they have always been for one query or report. However, all searches I have done for trying to use one...

I copied this and it runs the query but I am getting the same results. If a rep who didn't have any data in those dates are being extracted from the query.

Thanks for that catch, that was wrong I fixed that, but still not working right. Here is the new SQL: SELECT [Active Employee Information Query].Department, [Active Employee Information Query].[Employee First Name], [Active Employee Information Query].[Employee Last Name]...

I'm sorry I'm not quite following you

I have a query pulling from two queries. I have to be able to pull all the active employee names from the first query and even if they do not have any data for that day in the second query. My query works fine until I add a date parameter that is directed at the second query. When i tell it to...