Search results

Hi, I have a crosstab query which generates 35 columns under column heading. The report based on this query shows summary option for 20 columns only. How do I extend this to include all fields generated by crosstab query. When I try to add a summary for one of the fields in report design, it...

Hi all I have a date field in a table. In a query, I want to capture the startdate and enddate. However when I select the date field in two separate columns in the QBE grid and give [enter start date] & [enter end date] in criteria, the query on processing clubs the two and converts it into...

Hi I have 3 sub-reports in my report placed one below the other. I also have six test box controls which are adjacent to these sub-reports. Now, while previewing as well as printing the report, there are gaps between the text box controls which I think is because of the sub-reports. Is there...

Hi I am having a report which has calculated controls. 1. Is there any way I can filter the reported based on the value in calculated controls. 2. Also when I am exporting the report to Excel, the calculated controls do not get exported. Is there a way of achieving it. Basically, I want to view...

I have a form based on a Table for data entry. I converted one of the fields into a calculated control. But the field in the table does not get updated with this value. How do i bind the control to the field in the table.

I have a text box control in a report for calculating tax liability depending on taxable income and income slab. However I am not able to use nested IIF. How do i achieve it.