barbarao
Last Activity: Mar 17 '16, 01:53 PM
Joined: Apr 4 '13
Location:
-
Hi. I found a solution. Built a DISTINCT query on the table that has the Location ID and month, year, etc. Joined it to the table that has the ratings for the Location IDs. Seems to be working. Thanks for helping out. This site is terrific. -
Oh, looking at Rabbit's example, I probably can't get what I want based on his DISTINCT 2 and 3 sample. Any ideas on how I can get what I want? Write I now I just run it and then run some VBA on it to deleted duplicate IDs. Thanks again.Leave a comment:
-
Hi, Here is the SQL. I have two similar ones and this one is less complicated in terms or criteria. I have two tables - one for location and one for ratings. Rating get imported each month and are used for a variety of reports. I need to show the demographic for a location only if it has one or more ratings in the month. I don't need to know which rating it is just that it has rating.
This is what I currently get with the code...Leave a comment:
-
The above is what I want to see, not practice ID 4024 6 times. Hope that clarifies.Leave a comment:
-
Currently I am getting the location ID demographic data as many times as there are scores.Code:Practice ID Practice Name Practice Type Address 1 Address 2 Town Zip Code Phone New Pat YN Office Hours Web 4024 New England State Primary Care | Adults 7 South Avenue Portland 4103 (207) xxx-xxxx Yes M,W,F:8-4:30, T,Th: 8-6:30
Leave a comment:
-
DISTINCT not working as expected
Hi. I have a query that needs to pull all locations that have one score in a specific month/year (this combo will change monthly). (Some locations have multiple scores.) I thought a DISTINCT would do it but the results are the same as without the DISTINCT. I hope someone can assist. Thanks in advance.
...Code:SELECT DISTINCT dbo.PracticeTable.OPNumber AS [Practice ID], dbo.PracticeTable.PracticeName AS -
Ah, I didn't know that. I did learn that if you cut and paste into a mask field the mask is over ridden in the table.Leave a comment:
-
Phone number formatting
Hi. SQL back end Access front end. I have a table that contains a phone number field. It has a mask so the phone numbers will have () around the area code. I ran a stored procedure to export some of the demographic fields in that table and some records are not showing the () around the area code while they appear like that on the form the user enters data. Any ideas what might be going on? Thanks in advance. -
Hi,
I just rebuilt it and it is working fine. I use it on a button on a form. Thanks as usual for your support.Leave a comment:
-
The last one isn't working for the end user. It is available to everyone. She enters info in the two prompts and sees nothing while I see results. Any additional thoughts?Leave a comment:
-
I got some to work by writing the procedure in the Console instead of design view. Having trouble with one more but working on it now. thanks and hope all is well with you.Leave a comment:
-
Stored Procedure Not Working For End User
Hi, SQL Backend. Access Front End. I have a stored procedure that works fine for me but when an end user clicks the button that should run the stored procedure they get a message that the procedure can't be found. I know there is a simple fix for this but can't remember it. Hoping someone can help. thanks. -
Hi. I copied the query, renamed it, and the aliases show properly. Not sure why but at least I got it to work.Leave a comment:
-
All Column Aliases Not Working
Hi,SQL backend, Access front end. I have a query which has 6 column aliases. Only two of them are showing properly. Anyone have an idea of what could be going on? Query follows. Thanks in advance....Code:SELECT TOP 100 PERCENT dbo.ProviderNEW.NPI AS [Provider ID], 'Primary Care | Adults' AS [Practice Type], dbo.ProviderRelationships.OPNumber AS [Practice ID], dbo.ProviderNEW.LastName AS [Provider Name Last], -
Thanks. It is a hard loss for me as he was also my best friend throughout our lives.
Entity Susan, for example, who is owned by Entity Caesar, may have 4 guides as well. Entity Blake who is owned by Entity Susan, may have the same guides, different guides, or no guides at all. Entity Caesar, and all the other Entities like that one who are at the top of their family tree are not owned by another Entity nor do they have guides....Leave a comment:
-
yes but each guide would be a would be a differnt depth path and they would not have OWN aa a relationship type so i think this is the best I can come up with. Buidling a solution while mourning my only brother and supporting an 87 years old mother who lives 900 miles away isn't easy. This request came at an awful time for clear thinking so your help has been more than appreciated.Leave a comment:
-
I thought that the 10 2 7 for the company "Blake" would indicated that he is 7, his immediate owner is 2, and the owner of 2 is 10. You don't think that would work? Guess I don't understand the node concept. Thanks in advance....Leave a comment:
-
Hi. Just wanted to close the loop in case anyone finds themselves in this situation. Found a model, forgot what it is called, that offered the idea of a "depth" field to enter the level of who own what. For example, entity Caesar has an ID of 10. He is the highest. Susan reports to him and her ID is 2 so her depth is 10 2. Blake reports to Suan and his ID is 7 so his depth is 10 2 7. Gives me the ability to see an entire "family"...Leave a comment:
-
Thanks again. The only thing I can think of would be in the relationship table have an OWN1, OWN, OWN3 assigned to each entity then add a new field for Ultimate and enter the ultimate owner there. I'll keep research. Thank again.Leave a comment:
-
Thanks for the link. I will read it now. There can be only one ultimate owner, a next lever owner, one level after that, and probably one more. There are some entities related to things that are not owners and these may or may not have an ultimate ownder....Leave a comment:
No activity results to display
Leave a comment: