Prestwood IT: Acess 2003 basic Posts

Acess 2003 basic Posts

"Acess 2003 basic" Message Board Posts

Thread 1 of 1

gsempcb

Acess 2003 basic report question...

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

19 years ago

3 replies. Last post:
nashwannabe7	RE: Acess 2003 basic report question... Ok, I was mistaken. I thought since I had not directly addressed this that it was not yet fixed. But it appears to be self-correcting--possibly as a result of what I did in correcting the other field--as I now cannot make a query that returns any blank numeric values at all in the report. So that's great. Thank you for replying. 19 years ago

No activity last 2 weeks. Post a reply to make active.

3665
Hits

Prestwood eMagazine

Acess 2003 basic Posts

"Acess 2003 basic" Message Board Posts