Search results

No error message. Just $0.00

It sounds like it would work, but it doesn't. Any other ideas? Thanks MIke

Great, Thanks Mike

I have a form with the fields Amount and Deposit I then have two hidden fields which gives me a running total of both Amount =Sum([Amount]) and Deposit =Sum([Deposit]) I want to add a visible field to the top of the form which displays the current balance sum Deposit - sum Amount I...

I have two tables. The first is called 2tbl and the second is called final I want to write a query where if 2tbl.date_end=12/31/9999 populate final.emp as "yes" and 2tbl.mem = final.mem Any ideas? Thanks Mike

Between Date()-1 And Date() Worked! Thanks for the help Mike

The DB table which I'm quering has a field called DT_QUERIED and the data returned from this field is returned as 5/29/2009 9:29:56 AM I'm quering for records from yesterday. When I run this query I get no results (I know there is data there) SELECT NOLDBA_USER_AUDIT.USERID...

Please see my attachments for my question (picture is worth a 1000 words) Thanks Mike

I just tried [NUMBER OF DAYS]<Now() and worked fine. Thanks for looking

ODBC called failed. I'm connecting to an Oracle table.

I would like to make this part of a query to allow the user to enter the number of days they want to search by. NOLDBA_CASE_ROLLUP.DT_LAST_PAY)<=Now()-45 I tried NOLDBA_CASE_ROLLUP.DT_LAST_PAY)<=Now()-[days] but this didn’t work Would someone help please? Thanks Mike

Thanks for the info. I'll give your idea a try.

When this query is run the total amount for the first line should be $60 but it is not showing in the total field. Why? SELECT [DISBURSEMENTS 2].DT_BATCH, [DISBURSEMENTS 2].CD_SOURCE_BATCH, [DISBURSEMENTS 2].NO_BATCH, [DISBURSEMENTS 2].SEQ_RECEIPT, [DISBURSEMENTS 2].DISBURSMENTS...

The query is selecting (amoung other things) people that have an NOLDBA_INT_EMPLOYMENT_HISTORY.DATE_END which is null (in this case 12/31/9999). Some people have more that one NOLDBA_INT_EMPLOYMENT_HISTORY.DATE_END which are null so I only want to view the the max...

That's it. Thanks very much! Mike

In checking the table I'm doing the query against, the PERIOD_YYYYMM is a text field so I'm not sure if your response with work in this case. Here is the query. Any other ideas? SELECT NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE, NOLDBA_CASE_ASSIST_TYPE.PERIOD_YYYYMM...

A table I'm working with has a field PERIOD_YYYYMM which returns 201104 is there a way to format it to return as April 2011? Thanks

Thanks that should do the trick

I'm trying to count the number of cases where the license was suspended between two dates. I just want one number returned but I keep getting a list of numbers (i'm guessing they correspond to the dates) Is there a way to do this? SELECT Count(LICSUSP.CASEID) AS CountOfCASEID FROM LICSUSP...

A case could have more than one next accrual date returned that is greater than now( ). I only want the first accrual date greater than now( ). Is there someway to do that with this query? Thanks Mike SELECT NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE AS DO, NOLDBA_INT_CASE_STATUS.WORKER_ID AS...