in a query field, i want it to show a NULL column.
i went to do this -----> I want a blank Column:""
however, in excel, when i do a pivot, it shows "" instead of a blank. how do get acesss to produce a NULL column vs ""?
in a query field, i want it to show a NULL column.
i went to do this -----> I want a blank Column:""
however, in excel, when i do a pivot, it shows "" instead of a blank. how do get acesss to produce a NULL column vs ""?
Null AS MyDummyColumn
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Thank you. but if i were to use an iif statement, if True, how do i show as a NULL vs a ""?
Code:SELECT Transactions.ID, Transactions.TransactionDate, Null AS MydummyColumn,IIF(ID>10,Null,ID) as TT FROM Transactions;
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba