J Josef P. Well-known member Local time Today, 12:32 Joined Feb 2, 2023 Messages 1,052 Mar 22, 2024 #21 Note: I learned the NullIf function from SQL Server and thought it would also be good to use in Access/VBA.
Note: I learned the NullIf function from SQL Server and thought it would also be good to use in Access/VBA.
cheekybuddha AWF VIP Local time Today, 11:32 Joined Jul 21, 2014 Messages 2,846 Mar 22, 2024 #22 Most SQL flavours have NULLIF() T-SQL MySQL PostgreSQL ...
NauticalGent Ignore List Poster Boy Local time Today, 07:32 Joined Apr 27, 2015 Messages 6,712 Mar 22, 2024 #23 NullIf() = Good stuff. Adding it to the Code Vault.