I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardMS Access Interactive Topic   Print This     

Acess 2003 basic report question...

Acess 2003 basic report question... in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: question   Acess 2003   Acess 2003 basic   report question  
gsempcb
Tyler, TX USA

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 12 years ago (Thread Starter)
Comment Quote
About gsempcb -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12892, 3 replies
Thread Started 6/24/2008 4:48:46 PM
View Counter=3081
Last Reply Posted 6/26/2008 9:37:27 AM)
Location=Tyler, TX USA 
Joined=12 years ago   MB Posts=24  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.

Since the "default " default value for a numeric field is 0, how are you getting null values?  If the users are deleting the 0 change the validation rule to is not null

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

 Posted 12 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #12899 (Level 1.1)  Reply to 12892
Thread Started 6/25/2008 5:04:22 PM
Location=Home office in Fresno, CA. 
Joined=18 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
gsempcb
Tyler, TX USA

Double-posting I know, sorry about this:

The first problem is solved: I simply went to the query that is the backbone to the report, and for the "Hours Spent" field, I put a condition in the criteria, <>0 . So that's over and done with.

But I'm still looking for ideas on the second question. That is, regarding the other numeric field(s) needing to display "0" if the field is null/left blank. I thought maybe changing the underlying query to an "Update Query", and putting "Null" as the Criteria, and putting "0" as the "Update To". But the thing is, this is already designated as a "Totals" query, and changing it to a Update Query would restructure it. Is re-making a new query with just this one field designated as an Update Query and structuring it like this a good idea? Assuming I do create a query like this, and as this report will periodically be checked, what's a way I could automate it to run so that there's never any nulls, but always 0's in the final report?

 Posted 12 years ago (Thread Starter)
Comment Quote
About gsempcb -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12897 (Level 1.2)  Reply to 12892
Reply Posted 6/25/2008 4:03:17 PM
Location=Tyler, TX USA 
Joined=12 years ago   MB Posts=24  
Most Recent Post
gsempcb
Tyler, TX USA

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.

 Posted 12 years ago (Thread Starter)
Comment Quote
About gsempcb -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12901 (Level 1.3)  Reply to 12892
Reply Posted 6/26/2008 9:37:27 AM
Location=Tyler, TX USA 
Joined=12 years ago   MB Posts=24  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P184A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #12892 Counter
3081
Since 6/24/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech