Creating a macro query to prevent null records from exporting

[KapriRKarma]

Hi Team,

I am new to this platform looking for some guidance. I need help on creating a query to prevent null records from exporting to a excel file.

 

[Ranman256]

you dont need the macro, just make the query:
qsDataNoNull
select * from table where not ([field1] is null)

well then, i guess the macro is: transferspreadsheet ...."qsDataNoNull'....

 

[KapriRKarma]

Thank you, where would I put "qsDataNoNull" in the argument statement?

 

[Ranman256]

That is the name of the query..
use a macro, in it use command: transferspreadsheet....
(or TransferSOMETHING...)