Search results

  1. D

    Solved Serial number in Alphabets in MS Reports

    I want to assign serial number to each record via property>data>=1 overall. Its OK and serial 1, 2, 3 etc. However, I want to serial number alphabeticlly i.e a b c d and so on. I did this once in past using CHR(97), ASCII 97 represents a 98 represents b and so on. Unfortunately I could not...
  2. D

    Refering Parameter criteria from Forms to crosstab query

    I have few cross tab queries in my database. I wanted to get results in cross-tab basing on criteria from a combo on the form. If I have a fix value that works but if I execute query after having passed criteria from a combo on a form, it does not not work. Looking forward for guidance, please.
  3. D

    How to count records on each page including the count of all previous pages

    Dear All, may you live long. Example:- I have 20 records on page#1 and 21 records on page#2. On page#2, i want to show count of total records that is = 41. Similarly I have 9 records on page#3 and on the bottom of page#3, I wanted to show count result as 50. Regards and best whsihes
  4. D

    Solved Calculate previous record in current Record

    I am using a Db for calcualting pension. Pension is admissible on gross pension and then increases are added in gross pension. Every increase (percentage) is added in previous record and shown in current record. I am attaching the db as well illustrated the same as under: Gross Pension : 660...
  5. D

    How to make page footer invisible on last page of the report

    I have a report having multiple pages. The report has a report footer and page footer. I want not to preview pager footer on last page i.e alongwith report footer
Top Bottom