If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to Exclude one data entries if one field is "full"
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. |
#2
|
|||
|
|||
How to Exclude one data entries if one field is "full"
hi Russell,
Russell Pascoe wrote: 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 -- |
#3
|
|||
|
|||
How to Exclude one data entries if one field is "full"
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" wrote: hi Russell, Russell Pascoe wrote: 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 -- |
#4
|
|||
|
|||
How to Exclude one data entries if one field is "full"
hi Russell,
Russell Pascoe wrote: 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 -- |
Thread Tools | |
Display Modes | |
|
|