Search results

When I tried IIF(Nz([EST TYPE O],0) >0 And Nz([OPEN CASES],0)> 0,[EST TYPE O] / [OPEN CASES],0) I got error:Syntax Error (comma)in query expression 'First((Nz([EST TYPE O],0) >0 And Nz([OPEN CASES],0)> 0,[EST TYPE O] / [OPEN CASES],0) When I tried Nz([EST TYPE O],1) / Nz([OPEN CASES],1) I...

Problem A report has a Total field in the Report Footer to sum up the columns There is a column called OPEN CASES and a column called EST TYPE O In the Report Footer I want the sum’s of each of these columns and I also want the % of the sum of EST TYPE O / OPEN CASES. The sum of OPEN CASES...

Please see attachment. In the report footer I have the grand totals for all columns in the report. Example: Open cases 100 EST TYPE O 20 20/100 = 20% Could somone help with this? Thanks

So now I have another problem. When the percent amounts are caculated they look like % CURR PAID 1.50654913551264 OR 3683.92 I expected the results to be in this format 1.22% I have the field property set to percent. This query is used to populate a report. The field property in the...

Well I don't know if I'll ever understand why that worked, but it did. Thanks for all your time. Your one smart person when it comes to Access. Mike

I'm sorry for all my questions but I just can't seem to make the query give me the results I want. It would be helpful to me if you could take my query and make changes to it and return it to me. Thanks for all your help! Mike This is the query I now have SELECT...

"Wrong number of arguments with functionin query expression" Error message when I made these changes. Any suggestions? Thanks Mike SELECT NOLDBA_DISTRIB_BY_DIST_RESULT_TBL.DO_CODE AS DO, NOLDBA_REF_CASE_WORKER.WORKER_NAME AS NAME, NOLDBA_REF_CASE_WORKER.WORKER_ID AS CASELOAD...

OK I'll play around with it a little and see if I can make it work. Thanks Mike

That worked great, thanks! Now just one more question. What if ARREARS OWED=0 and ARREARS PAID is greater than 0 How and where would I put that into the query? SELECT NOLDBA_REF_CASE_WORKER.WORKER_NAME AS NAME, NOLDBA_REF_CASE_WORKER.WORKER_ID AS CASELOAD...

When I run the query below I get an empty field in the “% ARR PAID” field when there are no arrears paid. I’m assuming the error is in this line...

That worked thanks to the both of you. Someday I'll learn how to use Access, I hope! Mike

I'm still not getting what the two of you got. Please see attachment. Thanks Mike

Report contains address with blank lines - STILL PROBLEMS I'm still not getting what you got. I have attached a document with screen shots of the steps I took and my results. Help please Thanks Mike

I would like to attach a stripped version of the DB. After opening the DB go to FORMS and open PRINTING and click on the printer icon. Would someone pleae review and show me in this DB what needs to be done to fix it. Thanks for any help you can give. Mike

vbaInet, I'm not trying to piss you off, I'm just stupid. See attachment I have changed the NCPADDRESSLINE4 shrink and grow properties to yes I just don't understand When you say "Put this in just ONE textbox" are you saying to put =[Address 1] + Chr(13) & Chr(10) + [Address 2] + Chr(13) &...

OK I set textbox can grow and can shrink properties of these text boxes to yes. A1,A2,A3,city,state zip Set the Can Grow and Can Shrink properties of the textbox to YES. You will find them under the Format tab of the textbox's Property Sheet. I still don't understand where you want me to...

I'm sorry but I'm not sure where this is done. I have attached a picture of the document

I'm sure this might have been answered before but I can't find the answer. I have a report with the following fields Name Address 1 Address 2 Address 3 City, State ZIP When there is not address 3 and the report prints it is leaving a space between address 2 and City, State ZIP Is there a...

Thanks, I'll start with those

Can someone please tell me why I'm getting this error and how I can fix it. See attachment Thanks