Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. orion127

    Crosstab suppress some rows

    Thanks a lot, it's exactly what I need!
  2. orion127

    Crosstab suppress some rows

    In a cross tab I have this as a result blue red white green Total John 1 2 8 4 15 Mary 3 0 0 5 8 Tod 0 1 1 1 3 IF the sum of column "red" = 0 AND column "white" = 0, I don't...
  3. orion127

    Help on Optimising process of Large table

    Richard, I tried what you said, moving the set and close, but It's not faster. With the debugger I can conclude that the more record I process, the slower it gets. Is there anyway I can free some memory within the code? Anything else I can try? Sonia
  4. orion127

    Help on Optimising process of Large table

    Boriska40, I was trying to avoid importing because I didn't want to manipulate another file on the network, but It seems the only soultion so far. Richard, Getting the info from SAP is a matter of seconds. The bottle neck is in the inner loop I believe. I'll try what you wrote, and post the...
  5. orion127

    Help on Optimising process of Large table

    Hi all, I have a few customised SAP tables that I must import in Access. It works fine for the smaller tables. In my test DB one table has about 48000 records and it takes several hours to process (in my production Database, the number of records exceed 100000). I've tried splitting the...

Part and Inventory Search

Back
Top