Null values in access

However, I want to be able to look at the directional splits because, on a daily basis, the directional split between directions better be pretty darn close to or something's not working.

First, is there anything wrong with using a null value in the undefined direction of travel? For those where the difference is undefined, I don't give a flying fig.

This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites.

Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.

If you don't want some records in a query, you can filter the query: Apply a filter to view select records in an Access database. If you farmilar with SQL, you can edit the query sting and add a criteria in your code, then run the query and it will get your data without the Null values. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. Posted on October 24, 1 Comment. Share this : Tweet. Like this: Like Loading This entry was posted in "MS Access" , Basics.

Bookmark the permalink. Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:. Email required Address never made public. Name required. Search my blog Search for:. Blog at WordPress. Follow Following. Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Miss a tip? Editor's Picks. The best programming languages to learn in Check for Log4j vulnerabilities with this simple-to-use script. TasksBoard is the kanban interface for Google Tasks you've been waiting for. Paging Zefram Cochrane: Humans have figured out how to make a warp bubble.