Results 1 to 2 of 2

Thread: Number of records in a report

  1. #1
    keroed1 Guest

    Default Number of records in a report

    i am looking on some report previously developed by someone in access. i am trying to get the total number of records that are in the report i have the page numbers and the number of page correctly been displayed but when i try to display the number of record it doesnt work

    p.s. the form is built from a query that accepts start and endate to find the correct results

    i tried to thing
    1. i created a label and set the control source to "=count" that displayed a figure but it wasn't correct

    2. next i tried setting it to count(*) or count(column name)* and i get a #error when i run the report what am i doing wrong or can anyone shed any light on what i need to do
    Last edited by keroed1; Mar 6, 2007 at 11:02 PM.

  2. #2
    keroed1 Guest

    Default

    i got to fix it guys the prob was that i was trying to put the count in the footer but i guess that was out of the scope of the query so when i place it in body of the report it came up

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •