Recent content by kokiri

Thanks. I wasn't thinking. I forgot to expand the query window and only saw 2 queries.... Thanks.

Hi Duane, I'm reviewing your At Your Survey Statistic Reports and noticed that you used qselQstnTextRspnsxCount. How can I review this source? Thanks.

FYI, I just completed union query for all the questions like the way you recommended and received an err with "Query is too complicated". It didn't allow me to save it as one query so I made it to two query. I guess there is limitation of union query. Thanks.

Yes, I have records in my table. What is next step after you do union query all these answers? Thanks.

Yes, I know. I didn't like the fact that I have to repeat the same steps to create same results for all different questions. What do you recommend? I guess I need to restart my process. Do you have any steps or process so that I can accomplish what I'm looking for? Thanks.

Hi dhookoom, No, It is not too late to change my table structure, and I'll be more than happy to change it if I need to. What do you recommend? But I don't understand why I need to change it since this table collects only answers. I briefly looked at your sample demo and it is very...

Hi Remou & dhookom, Currently, this table contains all answers and it looks like below and ID is primary key along with doc_date: ID,doc_date,RN1,RN2,RN3,RN4...RN50+ 11, date,Yes, No, N/A,Yes... 13, date,No, Yes, , Yes... Thanks

Hi all, I have created queries (50+) to capture below information and these information is in one single table. Only thing different is column name. I used query option, because I have not figured it out different way. SELECT Sum(Abs([RN1]="Yes")) AS Yes...

The TheAceMan1 & MajP, Thanks for the help. It works! Thanks bunch!

Hi TheAceMan1, I tried Switchboard already, but no luck so far. It let you open the form but I wasn't able to cursor to focus on specific tab#. Can you be provide detail step. Thanks.

I'm new with forms. I have couple of forms and I need to be able to navigate different forms, pages, and tabs based on which command button is clicked. Form1: Page1...page5, page3, tab1...tab10, cmd1...cmd3 Form2: Page1...Page5, page3, tab1...tab10, cmd1...cmd3 Tried several options but so...

Hi Turkbear, In getfulldt function, I tested both format but results are same. It truncates and do not display hours and minutes. y := to_date(x, 'hh24mi ddMonYYYY') and y := to_date(x, 'hh24mi dd/Mon/YYYY') See below sample data and when I tested with your suggestion and I received an...

Santa, My vendor is using "Oracle" as their sales pitch. All of their application is developed in some legacy product and transfer the data to Oracle. Bottom line is that we made enough complaints but so far no luck. I just have to deal with it.

Hi DT, Thanks but I already tried that option and results are still same. select data, to_date(getfulldt(data)) visitdate from test ----- 2333 17Nov2005 17-Nov-2005 12:00:00 AM Thanks.

Hi all, Yes. BJCooperIt is correct. We cannot control on the front end. I just have to deal with it. I requested modification of application, but it may take years. Bill--I don't have permission to create triggers. FYI, I don't have permission to access tables. I'm only allow to access...