Recent content by Mike Hughes

I have two collums, currentowed and currentpaid. i want to add another field to my report showing the percent of currentpaid to currentowed but I can't seem to be able to make it work. I tried: =sum([currentpaid]/[currentowed]) and it doesn't work. Can someone help me?

Can someone help me convert this sql query so I can use it in access? I have no idea of how to do it. Thanks SELECT a.case_id FROM NOLDBA_INT_CASE_STATUS a, NOLDBA_RPT_CASE_CHG_IND b WHERE b.case_id = a.case_id AND b.sys_curr_date = (SELECT MAX (c.sys_curr_date)...

That did it. Thanks for your time. Mike

where does the format line go? SELECT [BATCH], [SOURCE], [NO], [SEQ], [LINE] FROM 7ef Format([NO],"0000") & Format([SEQ],"000")

I'm not sure how to do what you're suggesting.

I'm trying to combine 4 columns. Some of the columns have leading 0's and when I run my query I loose the leading 0's. BATCH SOURCE NO SEQ LINE 11012011 P 0048 005 25 SELECT [BATCH] & "" & [SOURCE] & "" & [NO] & "" & [SEQ] AS RECEIPT...

I figured it out. Thanks for taking the time to look. Mike =[COLLECTIONS]/Sum([COLLECTIONS])

Let me try and explain this again with more pictures. I have severall offices with a total collected field. In the report footer I have totaled the column (=sum([COLLECTIONS]). I would like to add another column to the report which would give the the % for each line of COLLECTIONS compaired...

I can't do this in a query it needs to be done in the report. See another screenshot I have attached.

Trying to create a new column in report to figure the % of collections to the sum of all collections for each district. Please see attachment. Thanks Mike

I just found one of my old posts which someone help me with so I have it now. =IIF([PAID CURRENT]=0 or [OWED CURRENT]=0,0,[PAID CURRENT]/[OWED CURRENT])

I have a report based on a query. In the report there are severl columns and I'm trying to figure the % of current paid to current owed. This % is figured on the report itself and not the query. The problem is that there are some records that have $0 current paid and $0 current owed. When...

I had someone experienced in sql (doesn't know Access) to write me this query to give me a count of cases where an EFN31 notice was sent and the date sent was greater than or equal to 4/23/2012. This is the query and it works fine but I would like it in access and I tried it in Access and it...

I got it, thank you for all your help! Mike

SELECT OA.DO, sub_CaseTotals.CountOfCASE_ID, sub_CaseTotals.CASE_TYPE, sub_CaseTotals.ESTABLISH_TYPE FROM sub_CaseTotals RIGHT JOIN OA ON sub_CaseTotals.IV_D_DO_CODE = OA.DO; That worked!! Thanks. One more thing is there a way to put 0 in the field where a district has no cases and can it...