+ Reply to Thread
Results 1 to 3 of 3
  1. 09-03-2001 01:48 AM #1
    Rhino302
    Rhino302 is offline
    Member Rhino302's Avatar
    Join Date
    Jun 2001
    Posts
    418

    Access 2000 Help

    I'm making a Query, and one expression has calculations with 10 feilds. It comes out OK, but I can't sort it. I get overflow everytime. What is the cause? I can sort a an expression with one calculation done to two feilds though.
    Reply With Quote Reply With Quote
  2. 09-03-2001 10:32 AM #2
    zskillz
    zskillz is offline
    Senior Member
    Join Date
    May 1999
    Location
    Denver, CO, USA
    Posts
    775
    well... I'm betting that the problem lies within the calculation that you're making. I obviously can't say for sure, but I bet that you're performing some sort of operation that overflows after a few sequences...

    -Z
    Reply With Quote Reply With Quote
  3. 09-03-2001 02:36 PM #3
    Rhino302
    Rhino302 is offline
    Member Rhino302's Avatar
    Join Date
    Jun 2001
    Posts
    418
    Hmmm, its odd. I just tried making a new field. My original calculation was called [Rating]. So I made another one Expr: [Rating]. That worked OK, and showed the same result, but when I tried to sort by the new expression, it asked for a value for [Rating].
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules






New Security Features Planned for Firefox 4
Another Laptop Theft Exposes 21K Patients' Data
Oracle Hits to Road to Pitch Data Center Plans
Microsoft Preps Array of Windows Patches
Microsoft Nears IE9 Beta With Final Preview
Simplified Analytics Improve CRM, BI Tools
Android Passes RIM as Top Mobile OS in 2Q
VMware Updates Hyperic System Management
File Monitoring Key to Enterprise Security
LinkedIn Snaps Up SaaS Player mSpoke