Results 1 to 12 of 12
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    (seemingly) strange query behaviour (2000)

    If you select Giugno(June) 1996 from the startup form of the attached mdb and run the QueryFermi query you see that the data for June in the query output are missing while they're present(together with July data) if you select July 1996 in the startup form.
    Any explanation for this?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (seemingly) strange query behaviour (2000)

    This is what i get.
    Seems the data for june is present.
    Francois

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (seemingly) strange query behaviour (2000)

    That's odd. Below is what I get.
    Are you opening the file in Access 2003?

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (seemingly) strange query behaviour (2000)

    No Access 2000 with Service Pack 3
    Francois

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (seemingly) strange query behaviour (2000)

    Which is what I use too. Do you use XP? I'm using W98SE.

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (seemingly) strange query behaviour (2000)

    I use windows XP SP2.
    Have you try the file you send on the lounge (Copia di Scalve) ? or do you use you original database ?
    Maybe by copying the data in a new db there was some kind of recovery of an error that is in the original db.
    Francois

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (seemingly) strange query behaviour (2000)

    I have the same problem in both files but I can try using XP SP1 tomorrow on the job.
    Thanks my friend. <img src=/S/gent.gif border=0 alt=gent width=17 height=25>

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: (seemingly) strange query behaviour (2000)

    Your screen shot shows 1995, Francois. Giorgio specified 1996. Could that be the difference?
    Charlotte

  9. #9
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (seemingly) strange query behaviour (2000)

    My screenshot is cropped to be 680 pixels large (I try to follow the rules <img src=/S/angel.gif border=0 alt=angel width=15 height=21> ) and the 6 seems a 5.
    There was no data for 1995 in the db.
    Francois

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: (seemingly) strange query behaviour (2000)

    Ah, if I squint, I can tell it is really a 6, but my eyes aren't what they used to be! <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    Charlotte

  11. #11
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (seemingly) strange query behaviour (2000)

    And, as a matter of fact, using Windows XP SP1 and Access 2003(though opening the mdb using the 2000 file format) it works like yours.

  12. #12
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (seemingly) strange query behaviour (2000)

    <img src=/S/rose.gif border=0 alt=rose width=15 height=15>

Posting Permissions

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