Search results

I got it myself. Thanks for looking. Mike

I have the query below and I want to remove the first 16 leading characters from NOLDBA_NOTES.DESC_NOTE. Right now for that field the query returns Amount Received:105. 105 is a dollar amount and that is all I want to see. Each record has a different dollar amount. I want to remove AMOUNT...

That worked. Thank you very much. Mike

In my report for each worker I’m trying to figure what the % of current paid to current owed. Some workers have no current paid ($0) or no current owed ($0) or $0 in both fields. When I run the report I get an error “Division by zero”. Could someone please show me how to fix this? See...

I plan on doing a mail merge which will include the case id(s) from the data collected with this query. There are clients who have more than one case id but I only want to send them one letter that lists both cases and I’m not sure how to do that. Is it something I do within this query...

I’m trying to figure out how to come up with the total number of cases in District WW which have an establishment type of P and a case type of A. When I run this query the results are showing as all blank fields in the table. My table has 4 columns, DO, P, A & CASES. I already know that the...

I'm sorry Bob, it did work after all. Thanks for the help Mike

That didn't work Bob =[PA_CASES]+[PM_CASES]+[PN_CASES]+Nz([PF_CASES],0)

Bob, can you show me where to put that in my query? SELECT PA.DO, NOLDBA_INT_CASE_STATUS.ESTABLISH_TYPE AS P, NOLDBA_INT_CASE_STATUS.CASE_TYPE AS F, Count(NOLDBA_INT_CASE_STATUS.CASE_ID) AS CASES INTO PF FROM NOLDBA_INT_CASE_STATUS INNER JOIN PA ON NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE =...

=[PA_CASES]+[PM_CASES]+[PN_CASES]+[PF_CASES] Using the Expression Builder I'm trying to add the numbers across a row. The problem is [PF_CASES] is NULL and it is causing nothing to be caculated (field comming up blank) Some months when I run this report the PF_CASES field will not be null...

is it possible to replace a null with a 0 when using the count function? Could that be a problem?

I've read several posts and still can figure out where to put Nz([fieldname],0) as somone suggested. I'm not sure if this is even correct. If the record count comes back null I want the query to insert a 0. Here is the query: SELECT PA.DO, NOLDBA_INT_CASE_STATUS.ESTABLISH_TYPE AS P...

That workedl, thanks again :D

I have a table and one of the columns contains the case type, which may be P,A,M,O & X. I would like to change all the X to N. Would someone explain to me how to do this? See screen shot.

OK, thanks again and I think I'll keep them where they are. Mike :D

I have the subreports in the Detail section, should they be somewhere else and where?

Just one more question. See screen shot Thanks Mike

Can you see me smile? Thanks so much. Mike

I'll also attache a screen shot of the report (with sub reports) which might give you a better idea of what I'm trying to do. Thanks for any help you could give. Mike

REPORT 2 IN THE REPORT FOOTER =sum([OA_CASES]) FOR THE FIRST COLUMN AND EACH OF THE OTHER COLUMNS. REPORT 3 IN THE REPORT FOOTER =sum([SA_CASES]) FOR THE FIRST COLUMN AND EACH OF THE OTHER COLUMNS. Then on the report containing all the sub-reports I’m trying to sum each column in the...