Search results

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]...

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 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...

Dear All I have a program about "complaints". It has a table-field "comp_status" which holds the data either "Pending" or " Resolved" and comp_recvd_date and comp_resolved_date. I have also a report for the program. In this report I used a calculated field "Aging" which calculate the aging of...

Dear all I have two batch files named as : 1) Combine.bat 2) Picenquiry.bat The contents of Combine.bat file are as: @echo off for %%A in (*.txt) do ( echo Processing file '%%A' FOR /F "delims=" %%L in (%%A) do ( ECHO %%L%%A >> DataFile.txt ) ) and contents of Picenquiry.bat are...

I have thousands of pictures in a folder. I want to display these pictures on a form. I used a blank continuous form having a field. whenever a user entered a number in this field form display the related picture. I used following as control source of the field. =("\\10.3.3.128\meter_pictures\"...

Dear All I have assigned a project to pick data from text file(s) and then import it in MS Access. Then run a query and a report and make a PDF format of report.Then place that reports on FTP server. All of it to be done by just clicking one or two buttons i.e. a script should be written that...

I am using a module in my access database. It is using for checking date in table.Actuallay what I need is that Module should check either Date punched on Form is already present in table or not. to do this I used following text. Public Sub chk_dat() Dim sql As Variant Dim a As Integer Dim b As...

I am using combo box on my form through which the specific record was found. the problem is that if required record not found then combo box shows a particular record. I need that if record not found then combo box should be empty and related sub form should also be empty or showing null record...