Results 1 to 9 of 9

Thread: [Access SQL] Missing Records with SubQuery

Hybrid View

  1. Oct 14th, 2008, 03:13 AM #1
    FunkyDexter
    FunkyDexter is offline
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,957

    Re: [Access SQL] Missing Records with SubQuery

    If whole records are missing then your sub queries aren't the problem. How many records are there in tblAKDAccount? That is the number you're latest query should return.
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd
    Reply With Quote Reply With Quote
  2. Oct 15th, 2008, 11:30 AM #2
    rack
    rack is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    Anchorage, Alaska
    Posts
    545

    Re: [Access SQL] Missing Records with SubQuery

    There are 26,357 Records.

    But that last query will pull anywhere from 26,251 to 26,357 records. If I run it over and over and over each time it comes back with total records somewhere inbetween those 2 numbers. Its werid.
    Please RATE posts, click the RATE button to the left under the Users Name.

    Once your thread has been answered, Please use the Thread Tools and select RESOLVED so everyone knows your question has been answered.

    "As I look past the light, I see the world I wished tonight, never the less, sleep has come, and death shall soon follow..." © 1998 Jeremy J Swartwood
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width