Query Syntax difference between .EX. and .TV.

The Quickbase Junkie has a nice help page on Query Syntax, which have many uses including to be used on Formula Queries. How to write Queries in Quickbase What is the difference between the oper...