report question Posts

Dear all,  I just got a paradox report on our legacy system - paradox 7 for windows. I need to find out what is the underlying data for the report. I opened the report in design mode and look at the data model. It has three tables, two of them linked. Two of them are priv table. I can find the two priv tables - one empty and the other one has data. how can I find which query makes the process? thanks for your help!

Posted to MB Topic: Paradox Reports « Paradox Board

I am using Access 2003. Say you've got a report that draws some fields from a query, then spits out their values on a report. Now what if I wanted to set some sort of condition on one of the number data-type fields such that, "If is blank/zero, don't display other field."  In this report, say I want to set it up such that "If 'Hours Spent' is blank/zero, then don't display 'Project Description' (or make it blank--whatever)." And then, how would you do something like "If 'Hours Spent' is blank/zero, then don't show that particular record at all." ? Is this possible?

Posted to MB Topic: MS Access Interactive « Access Board