‘####’ AS TEXT (Access 2000)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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?

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote