Results 1 to 7 of 7
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: '####' AS TEXT (Access 2000)

    Are you sure there are no other criteria involved? I did a small test in Access 97 and the <> "####" criteria worked as expected.

  2. #2
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    '####' AS TEXT (Access 2000)

    In a query I wish to omit data where the text a the field is 4 hashes.

    <> "####" returns no data at all. Why?

    Am I missing something fundamental about the hash key here?

    Forgot something - the data resides on SQL Server 6.5

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: '####' AS TEXT (Access 2000)

    You are not missing anything. <>'####' will return all data in the query (assuming you are using the query grid) not equal to #### as requested. Are you sure there is data other then #### in the data you are querying?
    Regards,

    Gary
    (It's been a while!)

  4. #4
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: '####' AS TEXT (Access 2000)

    Yes, there are lots of other text (and blank) entries.

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: '####' AS TEXT (Access 2000)

    Without knowing anything else, I would agree on Hans on this one. The query should execute. Are other filters being applied to the data as well? I tested the <>'####' in Access 2000 and had no problems.

    Perhaps your data is actually #### with either trailing or leading spaces. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Regards,

    Gary
    (It's been a while!)

  6. #6
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: '####' AS TEXT (Access 2000)

    The field size is definately only 4 characters & there aren't any spaces. The data is downloaded (by me) from our antiquated mainframe & uploaded to an SQL Server (6.5) for storage.

    OK, just did some more testing. If I put <>"####", it returns data that isn't "####" BUT it also omits blank fields, which I require.

    Sorry if I seem to be leading you a merry dance.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: '####' AS TEXT (Access 2000)

    Omitting null values is as expected. If you want to include null values, add
    Is Null
    in the criteria line below
    <> "####"

    Alternatively, you can edit the original criteria line to
    <> "####" Or Is Null

Posting Permissions

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