Search results for query: *

select distinct ((concat(trim(EXTRACT(month FROM(rqst.admt_dt))), '/01/', trim(EXTRACT(year FROM(rqst.admt_dt))))) as date format 'mm/dd/yyyy' end) as MonYr from companydatabase.um_rqst rqst The DD could be any day of a month but we are forcing it to the first of the month with the 01...

I started to do an update query like: update comprank set ranking = '1 out of 1' where measureid = '234' and prodabbrev = 'hmo' and rank = 1 and market = 'ca; but then I realized that is not going to work based on the raw data I have. Here is an example of the data and I also have 3924 total...

I deleted my old post and reposting since I did not make myself clear what I was looking to do. I have a 4800 approx. row database in SQL Server. I need to either take that data and in SQL Server perform SQL code to be able to pivot the data. An example of some pivot code is: SELECT...

I have a very large table and one of the columns is a char(25) datatype. The problem is not all the data in this column has the same length yet when I query to get the distinct length, everything comes back 25. I need to alter some of the data and was trying to do it by the length. Here is an...

I have the following code and it worked when my tables were in Access, however the tables have been migrated to our Teradata server and I ODBC with Access. My tables are now named for example DL_QPT_CQE_Measures. I tried changing my code to DL_QPT_CQE_Measures.hedis_measures, however it does not...

I am getting an error where my export to graph button on the Excel portion of my code cannot find the pivot table property in my Excel sheet. The error is run-time 1004 and it says unable to get the pivottables property of the worksheet class. Here is the code I have and I commented where the...

I have a large Access db and created all my tables that are normalized, created forms, reports, and queries. I used fake test data that consisted of 14 rows. Everything looked great until I appended REAL data that overwrote the 14 rows and added 50k more rows. The forms are not picking up this...

MajP, you help!!!! You helped me so much with the GetFilterFromListBox issue and now I have another issue. I am taking the results of that information and have a button where my end-user can click on it and it takes them to a report with a subform pivot graph in my footer/or header. I prefer the...

I have a database and a main form that takes information from several listboxes where the user can select whatever they want and then click the button that is click to see results and they will see them in the detail section. I want them to if they want click the button that says click to go to...

I have 11 listboxes and have been reading and researching for almost 2wks now with nothing that is helping. All I attempt does not work. the 11 listboxes the user can select 1 or more items from each. Then I need what they select to be used as the filters for a query. My listboxes are unbound...