How to Exclude one data entries if one field is "full"

[Guest]

Hi there!

I run a property business. I have a database of tenants in my properties. I
print a report that I call a Contact Information Report. I would like to
exclude from this report any tenant who has moved out, and therefore has an
entry in the field "Date Moved Out".

I suspect that this is desperately simple - but it has foxed me for some
while! - can anyone help me please?

Thanks in advance.
Russell.

 

[Stefan Hoffmann]

hi Russell,

I would like to
exclude from this report any tenant who has moved out, and therefore has an
entry in the field "Date Moved Out".

Modify the data source of your report, add a criteria for your column
"Date Moved Out" with "IS NULL".


mfG
--> stefan <--

 

[Guest]

Stefan,

Thank you for your response.

I got there eventually, but I suspect I went the long way around. I got the
gist of what you were saying, but couldn't work out how to change the Data
Source, so I created a query, and then produced a Report based on the output
of the query.

Was this the long way round, and so, was your method the easy way? How do I
get to the Data Source manipulation?

Thanks in advance for your assistance.
Cheers.
Russell.

 

[Stefan Hoffmann]

hi Russell,

Was this the long way round, and so, was your method the easy way? How do I
get to the Data Source manipulation?

No. It is the right way. You have only done one step more. Instead of
creating an extra query i had the following in mind:

Open your report in desgin view.
Open the property editor for your report, go to the data page.
If there is only a table listed, you can press the "...".
When you are finished, you don't need to save it as an external query.
It can be saved as "inline" query.


mfG
--> stefan <--