Results 1 to 4 of 4
  1. #1
    messier is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    15

    Query

    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 ""?

  2. #2
    Welshgasman is offline Expert
    Windows 10 Access 2007
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    622
    Null AS MyDummyColumn
    Please, please use # when posting code snippets.
    Cross Posting Etiquette: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?search_query=debug+access+vba



  3. #3
    messier is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    15
    Thank you. but if i were to use an iif statement, if True, how do i show as a NULL vs a ""?

  4. #4
    Welshgasman is offline Expert
    Windows 10 Access 2007
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    622
    Code:
    SELECT Transactions.ID, Transactions.TransactionDate, Null AS MydummyColumn,IIF(ID>10,Null,ID) as TT
    FROM Transactions;
    Please, please use # when posting code snippets.
    Cross Posting Etiquette: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?search_query=debug+access+vba



Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums