WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Report with Duplicates

 
   Home -> Office other -> Reports RSS
Next:  how to automate running and access report with pa..  
Author Message
JD McLeod

External


Since: Jun 16, 2005
Posts: 20



(Msg. 1) Posted: Thu Jul 24, 2008 6:14 am
Post subject: Report with Duplicates
Archived from groups: microsoft>public>access>reports (more info?)

I have a database with the following fields:
Audit Section
Audit SubSection
Audit Steps
Findings
Recommendations

For some audit subsections, there can be more than one audit step. If the
auditor has findings, they have to enter those findings and recommendations
into a form on an audit step by step basis. This form has “None” as the
default so they do nothing if they have no findings or recommendations for a
particular step. I want to create a summary report that shows audit results
by audit section and audit subsection (not audit step). If there are no
findings, the report prints “none” and if there is more than one step with no
findings, I tell the report to hide duplicates. Works fine so far. If there
is more than one step and there are findings for each step, again no problem.
Where I run into a problem is when I have a section with multiple steps and
one has a finding and one does not. The report shows both the finding and
the word “None”. In this case, if there are findings for one step, I want
the report to show the finding(s) and not the word “none”. Any thoughts on
how to accomplish this?
Back to top
Login to vote
Display posts from previous:   
       Home -> Office other -> Reports All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
 Office
  Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET