If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Empy String vs. Null
I should know and understand this, but I don't. Could somebody please
review the difference between these to values? I have a column that either contains a code or it does not, but I have to test for both null and "". I just can't understand the difference. Please 'splain it to me. TIA Paul Hammond -- |
#2
|
|||
|
|||
Empy String vs. Null
When I filter the data, I keep in mind few things
In a Number and date field, I check for Null In a Text field I check for Null and Empty the text field before any value been enterd into will return a Null, but if a value was entered into a text field, and then been deleted by the user in the form, will return empty. If I'm wrong by that I'll be happy if somebody will correct me. -- I hope that helped Good Luck "Paul Hammond" wrote: I should know and understand this, but I don't. Could somebody please review the difference between these to values? I have a column that either contains a code or it does not, but I have to test for both null and "". I just can't understand the difference. Please 'splain it to me. TIA Paul Hammond -- |
#3
|
|||
|
|||
Empy String vs. Null
Think of Null as meaning "Unknown"
Take a look at the Employee table in the Northwind database that came with Access. There are fields for information about the employee, including who they report to. If you were to add an employee to the table, and you didn't know to whom they reported, you'd leave the ReportsTo field as Null, because it's unknown (at least to you). Once you found out, you'd fill the field in. If, however, a particular person didn't report to anyone, you'd put blank in, because now you know to whom they report, and it's no one. (I know, not the greatest example, but it was the easiest to think of in terms of databases to which you should have access!) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Paul Hammond" wrote in message ... I should know and understand this, but I don't. Could somebody please review the difference between these to values? I have a column that either contains a code or it does not, but I have to test for both null and "". I just can't understand the difference. Please 'splain it to me. TIA Paul Hammond -- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Criteria to run Parameter Query for a report | questionnaire database analyst | Running & Setting Up Queries | 4 | September 18th, 2005 06:06 PM |
What if the back-end "moves"? | John S. Ford, MD | General Discussion | 13 | November 15th, 2004 09:33 PM |
UNION Query with Criteria | Dkline | Running & Setting Up Queries | 1 | August 4th, 2004 09:15 PM |
Importing from a text file | filnigeria | General Discussion | 3 | July 8th, 2004 03:28 AM |
Access inconsistencies | Hoopie | Running & Setting Up Queries | 2 | June 15th, 2004 10:53 AM |