sql nulls vs access nulls

Posted on 2009-05-22
Medium Priority
Last Modified: 2013-11-28
I am doing a data conversion from MS Access to SQL Server 2008.  The user is asking to see a particular original report against the new report to ensure that data is converting correctly.  It appears that SQL Server 2008 handles NULLS differently than Access, because the report sources are off by 7 records (7987 to 7980).  

Is there any way around this because the NULLS are intentionally saved in the database because it means something different than 0 Units.  
Question by:busapps
LVL 12

Accepted Solution

geowrian earned 600 total points
ID: 24456660
The "report" should be the same. What is the query that provides the data for the report?
LVL 31

Assisted Solution

RiteshShah earned 450 total points
ID: 24456668
I don't think so NULL will be handled differently, there may be some different reason which could be found after seeing your table structure and query.
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 450 total points
ID: 24456747
It is not that Nulls are different between MS Access and MS SQL Server, but it is the way you treat them that makes it different.  MS Access uses a different SQL syntax when dealing with null in comparison to T-SQL.

Author Closing Comment

ID: 31584628
Turned out the problem was in the query of the original report.

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question