Number of records found

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Les Stout
    #1

    Number of records found

    Good day,

    I am not sure if this is the right forum for this question, but would
    appreciate any help.

    I have a spread sheet with a lot of rowws in, about 5000 and before i
    deleted a lot i had 9000.
    The question is that when i filter by a certain criteria, i get a
    message at the very bottom of the spreadsheet saying; "500 of 9540
    records found".
    Can a person change this or is this something that Excel does itself ?

    Les Stout

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Tags: None
    • Robert
      #2
      Re: Number of records found


      "Les Stout" <les.stout@bmw. co.za> wrote in message
      news:404335c4$0 $199$75868355@n ews.frii.net...[color=blue]
      > Good day,
      >
      > I am not sure if this is the right forum for this question, but would
      > appreciate any help.
      >
      > I have a spread sheet with a lot of rowws in, about 5000 and before i
      > deleted a lot i had 9000.
      > The question is that when i filter by a certain criteria, i get a
      > message at the very bottom of the spreadsheet saying; "500 of 9540
      > records found".
      > Can a person change this or is this something that Excel does itself ?
      >
      > Les Stout
      >
      > *** Sent via Developersdex http://www.developersdex.com ***
      > Don't just participate in USENET...get rewarded for it![/color]

      This is an Access forum, not an Excel forum, so you're fear is correct. Why
      do you have so many rows in your spreadsheet?


        Comment

        • Les Stout
          #3
          Re: Number of records found

          Thank you for your reply, this is a spreadsheet generated from various
          main frame db2 systems.
          It is extremly big,i actually break it into smaller pieces and pul it
          into access as i have to create certain comparisons and graphs. I break
          it up as if i pull the whole thing in i get errors.

          Les Stout

          *** Sent via Developersdex http://www.developersdex.com ***
          Don't just participate in USENET...get rewarded for it!

            Comment

            • Trevor Best
              #4
              Re: Number of records found

              Les Stout wrote:[color=blue]
              > Thank you for your reply, this is a spreadsheet generated from various
              > main frame db2 systems.
              > It is extremly big,i actually break it into smaller pieces and pul it
              > into access as i have to create certain comparisons and graphs. I break
              > it up as if i pull the whole thing in i get errors.
              >
              > Les Stout
              >
              > *** Sent via Developersdex http://www.developersdex.com ***
              > Don't just participate in USENET...get rewarded for it![/color]

              Excel is possibly the single worst POS for handling data there ever was,
              great spread sheet, but really crap for data. even if you get the number
              of rows right you'll bound to end up with data type errors. IME it's the
              worst thing to use as an intermediary data transfer program. Consider
              ASCII files (CSV, fixed length.

                Comment

                • Robert
                  #5
                  Re: Number of records found


                  "Les Stout" <les.stout@bmw. co.za> wrote in message
                  news:40442024$0 $198$75868355@n ews.frii.net...[color=blue]
                  > Thank you for your reply, this is a spreadsheet generated from various
                  > main frame db2 systems.
                  > It is extremly big,i actually break it into smaller pieces and pul it
                  > into access as i have to create certain comparisons and graphs. I break
                  > it up as if i pull the whole thing in i get errors.
                  >
                  > Les Stout
                  >
                  > *** Sent via Developersdex http://www.developersdex.com ***
                  > Don't just participate in USENET...get rewarded for it![/color]

                  Well, you need to explore other possibilities. Good luck.


                    Comment

                    • Tempy
                      #6
                      Re: Number of records found

                      Thanks for the help, much appreciated

                      Les Stout

                      *** Sent via Developersdex http://www.developersdex.com ***
                      Don't just participate in USENET...get rewarded for it!

                        Comment

                        Previous template Next
                        Working...