Recent content by wasim_sono

Thanks to all who give their precious time. Actually I'm using nz function wrongly. but thanks God as well as all of you that I identify the problem and resolve the matter.:)

I tried but not working.

I created a report with crosstab query. When I run the report it shows data and some fields which have no data display as blank. I want to replace 0 rather than blank or spaces. I used NZ([SumOfAmount],0) and IIF([SumOfAmount]="",0,[SumOfAmount]) but doesn't work and give space error. I...

wasimssgc I have a crosstab query like TRANSFORM Count(Trans_tbl_dom.consumer_no) AS CountOfconsumer_no1 SELECT Q_Img_Summary_code2_dom_1.Area, Q_Img_Summary_code2_dom_1.book, Q_Img_Summary_code2_dom_1.CountOfconsumer_no AS [Total Customers], Q_Img_summary_code2_dom_2.[Accurate / Only index]...

I want to hide entire record.

Thanks Gasman But the problem is that I have to remain the data in report other wise report doesn't work. Is it possible that write some code on report format event to hide that particular record.

Dear All I have a report based on crosstab query. I always insert dummy data as well as actual data in table and then run report. Dummy data has values "0". I want to hide this dummy data whenever I run the report.

Dear June7 I'm sorry that I 'm using field instead of control. There is a control namely "Text119" in footer section of empno group which shows the total for "Incentive" control. I also used a calculated control namely "TnInc" in footer section of SubZone group to sum the calculated control...

Dear all I have a report with three groups namely Sub_Zone, Billing_month, and Empno. I used a calculated field in detail section namely "Incentive". I used a calculated field namely "txtRunInc" in Empno group to sum the "Incentive" field which is working properly. I also used a calculated...

Re: [RESOLVED]Decision on calculated field in Report Thanks for every one for your valuable help. :) It resolved. The error was due to using "Aging" field as bound field. I just unbound it and got result.;)

Re: [RESOLVE] Decision on calculated field in Report Thanks all of you for your valuable help. :) I was using Aging field as bound field. I just unbound it got result.

Thanks a lot Pat Hartman for your valuable guidance. but when I used "Date()" in my code it never accepted and automatically converted to "Date" only. Now I'll use the same in my coding. Hello Mark I really appreciate your code but when I used this in my program I got following run-time error...

yes of course, but how to print on report? please see attached report.

Actually "Aging" field tells the status that how long was it "pending" or what time it took to "Resolved".

I used following code: If Me.Comp_Status = "pending" Then Me.Range = DateDiff("d", Me.Comp_Date, Now()) ElseIf Me.Comp_Status = "Resolved" Then Me.Range = DateDiff("d", Me.Comp_Date, Me.Resolve_Date) End If Aging is replaced by Range. When I run the report it gives run time error as...