Search results

Thanks---Mike

Thanks for the info...your correct the DBA would not be happy!

I posted this under FORMS at first but the question might be better posted here I have a DB which opens to a form, the form contains one command button which runs VB script which runs some queries and then creates a table and emails that table to some of my workers. I have two questions: 1. Is...

No, that didn't work: SELECT [2 WORKER CASES].CASELOAD, Count(NOLDBA_INT_CASE_STATUS.CASE_ID) AS [CLOSED CASES] INTO [TABLE 15] FROM [2 WORKER CASES] LEFT JOIN NOLDBA_INT_CASE_STATUS ON [2 WORKER CASES].CASE = NOLDBA_INT_CASE_STATUS.CASE_ID WHERE NOLDBA_INT_CASE_STATUS.CASE_STATUS="C" AND...

There are no closed cases in this CASELOAD and nothing is being inserted into TABLE 15. Not the CASELOAD name or the number of CLOSED CASES in this case '0'. Is there a way to have the query insert the CASELOAD 'name' and the number of CLOSED CASES as '0'? SELECT [2 WORKER CASES].CASELOAD...

I have a form with a comman button with an on click event procedure shown below. It runs and emails several reports each time I run it. I would like to know if there is a way to set this up so it would run each day at a set time without me being at the computer. (as long as the computer is...

This query returns the results shown below it. I would like to pick up the MAX "GLOBAL_BEG" and in this case it would return only one line: CASE...........ID.........TYPE...MED........GLOBAL_BEG 20139847P.CARDCFM....C...... A.......... 431580408 Can this query be changed to do this and if...

That doesn't help me much.

When this form opens it contains only one field. That field has data in it and it also contains a blinking cursor and the text/number in the field is highlighted. Is there a way to prevent this? Thanks

I have a federal audit coming up and to assist me in answering questions I created a DB to collect the data which will be questioned. The DB has a form I'll call the MAIN FORM. This consoldiates case data in one place for easy access. Each case has a unique identifer field "NO" (for number)...

This query is used to determine the number of days between the last payment being received and today. If there has never been a payment (no MAX DISB date) the field is empty. Is there a way to have something like NULL inserted in the days field for that record & can you show me how to do it...

OK....I just could not see that.....Thanks for making my face red.

I'm having a problem with this query. SELECT [TABLE E].USERID, [TABLE E].CASE, [TABLE E].SCREEN, [TABLE E].START, [TABLE E].END, DateDiff("S",[START],[END]) AS SECONDS FROM [TABLE E]; I will not caculate the correct number of seconds for line 3 in this table. It should be returning 58...

I used the first example and that worked good for me. thanks for your help

I'm trying to figure the difference in time between the START and END fields Both the fields are DATE/TIME fields. All the differences will be in minutes and seconds, the date will always be the same. Attached is a shot of the table. SELECT [TABLE 5].USERID, [TABLE 5].CASE, [TABLE...

I don't know how to pull this, but I don't need an answer to this. I'm going to go at it a different way.

Trying to determine the amount of time a USERID stays on the ELOG or NOTE screens. In this case the user NAV TO ELOG at 12:28.27 pm Then started viewing CASE 20028294P at 12:28:28 PM Then the user NAV TO the CMEM SCREEN at 12:28:38 PM So this user viewed the ELOG screen for 10 seconds I have...

The first one worked! Thanks SELECT NOLDBA_USER_AUDIT.USERID, NOLDBA_USER_AUDIT.ID_CASE, NOLDBA_USER_AUDIT.ID_SCREEN, NOLDBA_USER_AUDIT.DT_QUERIED FROM NOLDBA_USER_AUDIT WHERE (((NOLDBA_USER_AUDIT.USERID)="HW4THIL") AND ((NOLDBA_USER_AUDIT.DT_QUERIED) Between #2/10/2009 12:00:00 AM# and...

I have this SQL query select userid, id_case, id_screen, dt_queried from noldba.user_audit where trunc(dt_queried)='10/FEB/2009' AND userid='HW4THIL' order by DT_QUERIED It returns this: Userid Id ............Case Id........... Screen .............Dt Queried...

That worked great! Thanks