Query Entity Names, and Column Names

[Accidental DBA]

Ok, so this request was a weirder one. I need to create a query from a flat file that I got from our contracting dept.



I have a table that table that has Business Name, Tax-ID, Contracts...

We collect a percentage of collections through our contracts.

So I want to print a list of business names, and then the CONTRACT Name for any business that has no submissions. It's easy to print the business name and then the values, but I just need the contract name ONLY if the submission is Null. Any help is appreciated.

[alansidman]

In the design area for your query. In the grid, put the fields you wish to have in the result. Make sure to include the field that shows submissions.

In the criteria for the submissions field, type IsNull

Alan