Advertisement
- Home
- Microsoft
- Development
- MS Access
- Access Front End Query's & SQL Backend Data Null Value
Advertisement
- 1. capricorn1 2,357,876
- 2. DatabaseMX 1,578,962
- 3. LSMCons... 738,913
- 4. boag2000 655,583
- 5. peter57r 538,288
- 6. GRayL 451,989
- 7. harfang 437,453
- 8. jimhorn 322,342
- 9. cactus_d... 299,026
- 10. matthews... 256,874
- 11. TextReport 236,057
- 12. hnasr 232,150
- 13. ee_rlee 173,155
- 14. angelIII 163,304
- 15. puppydog... 149,767
- 16. jimpen 149,684
- 17. mbizup 147,354
- 18. jefftwilley 140,435
- 19. LPurvis 139,254
- 20. JezWalters 138,435
- 21. omgang 130,049
- 22. Rick_Ric... 126,252
- 23. koutny 122,251
- 24. tbsgadi 120,968
- 25. MikeToole 118,626
- 1. capricorn1 10,014,914
- 2. nico5038 5,704,781
- 3. rockiroads 5,409,687
- 4. peter57r 3,982,783
- 5. LSMCons... 3,475,503
- 6. DatabaseMX 3,462,423
- 7. LPurvis 3,398,221
- 8. shanesue... 3,288,317
- 9. harfang 3,054,286
- 10. stevbe 2,857,111
- 11. jimhorn 2,741,934
- 12. GRayL 2,611,833
- 13. flavo 2,111,583
- 14. mbizup 2,033,944
- 15. jadedata 1,964,977
- 16. jefftwilley 1,799,875
- 17. thenelson 1,697,869
- 18. matthews... 1,594,087
- 19. eghtebas 1,487,093
- 20. boag2000 1,338,327
- 21. puppydog... 1,329,230
- 22. Arthur_... 1,285,298
- 23. cactus_d... 1,271,815
- 24. jjafferr 1,265,357
- 25. dannywar... 1,260,596
| 06.15.2008 at 12:40AM PDT, ID: 23485915 |
|
[x]
Attachment Details
|
||
Access Front End Query's & SQL Backend Data Null Value
Asked by lukestclair55 in Microsoft Access Database, MS SQL Server, SQL Server 2005
Tags: microsoft, access, 2000
Hi,
Currently looking at migrating our Access BE to a SQL BE, which I have used the upsizing wizard in Access 2007 as this is more compatible with SQL2005. The front end we use is 2000.
In one of my query's it throws an error will the criteria of a field 'is null'. This is not supported within SQL. How do I overcome this? Screenshot is attached.
Are there any other Ms Access query functions that are not supported in SQL that need to be altered so that they will work?Start Free Trial
Currently looking at migrating our Access BE to a SQL BE, which I have used the upsizing wizard in Access 2007 as this is more compatible with SQL2005. The front end we use is 2000.
In one of my query's it throws an error will the criteria of a field 'is null'. This is not supported within SQL. How do I overcome this? Screenshot is attached.
Are there any other Ms Access query functions that are not supported in SQL that need to be altered so that they will work?Start Free Trial
Attachments:
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628
