InstructionWhich7142
Registered User.
- Local time
- Today, 22:05
- Joined
- Feb 24, 2010
- Messages
- 203
I've got an MSSQL 2014 express server that i've started using as data source to interrogate some data from our shift and access control system,
So far it's been a really pain for regional settings etc, especially two key fields for roughly "shift minutes" that are both currency rather than number, these initially all came across as 0 until I disabled the regional setting in the SQL link and also used "SQL Server Native Client 11.0"
However the same two fields also play havoc if an outer join results in them being null in a subsequent query, I get "invalid use of null" etc
I've somewhat bodged around this by using a totals query to kind of "force" Access to handle the data itself rather than poking it back to SQL and getting dumb errors.
However this has now ended up with a load of fields spitting out as text when I've applied an NZ() function to them, even though the null result should be 0, I just don't get it, is there a guide to Access and SQL somewhere? I thought it'd just "GNU" lol
So far it's been a really pain for regional settings etc, especially two key fields for roughly "shift minutes" that are both currency rather than number, these initially all came across as 0 until I disabled the regional setting in the SQL link and also used "SQL Server Native Client 11.0"
However the same two fields also play havoc if an outer join results in them being null in a subsequent query, I get "invalid use of null" etc
I've somewhat bodged around this by using a totals query to kind of "force" Access to handle the data itself rather than poking it back to SQL and getting dumb errors.
However this has now ended up with a load of fields spitting out as text when I've applied an NZ() function to them, even though the null result should be 0, I just don't get it, is there a guide to Access and SQL somewhere? I thought it'd just "GNU" lol