Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How do I make a field print only the Tags that are there?

Posted on 2011-02-18
22
281 Views
Last Modified: 2012-06-27
I have an Access 2003 database.  It is very robust.  It has one field that displays the tag number in the report whether it has tag numbers for it or not.  I want to make it where it displays only the tag number if it is present.  When you go to print report, the very last one on the right and prints a report showing the tags, whether they should be there or not.
0
Comment
Question by:datadigi
  • 13
  • 7
  • 2
22 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34929765
a copy of the db will help.
0
 
LVL 44

Expert Comment

by:GRayL
ID: 34929775
I don't understand your question.  Please try again.
0
 

Author Comment

by:datadigi
ID: 34933605
re-posting it with database
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:datadigi
ID: 34933662
I have an Access 2003 database.  It is very robust.  It has one field that displays the tag number in the report whether it has tag numbers for it or not.  I want to make it where it displays only the tag number if it is present.  When you go to print report, the very last one on the right and prints a report showing the tags, whether they should be there or not.

Also, it doesn't print all reports.  I would like a button added to it to print all reports at once that have information and not the ones that don't. PROSEP-DYPROTEC.zip
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34934281
how do you determine whether the Tag number should be on the report or not?
0
 
LVL 44

Expert Comment

by:GRayL
ID: 34934677
The mdb inside your zip file is over 112MBytes long.  You should pare the mdb down to the minimum required to support the question, do a Compact & Repair, and then re-post here.  Normally, a mdb, prepared in such a fashion will be well under 10 MBytes and thus will not need to be Zipped.  If that becomes the case, you should then remove the original Zip file.
0
 

Author Comment

by:datadigi
ID: 34934679
When you go to print, then to the last option on the right - the "PLC I/O Count Summary by PID" list everything.  It list it where the tag number prints through out the report whether it is there or not.  It is the 1, listed on everything.  If there is a 1 there it should print, if there is not a 1 there it should not print.
____________________________________________________________________________________

Also on the reports, could you make a "print all button" to print all the reports that have data in them?
0
 

Author Comment

by:datadigi
ID: 34934686
I will try shrinking the database and then re-posting it.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34934697
< It is the 1, listed on everything>  where do you find the "1"? on what field?
0
 

Author Comment

by:datadigi
ID: 34934720
You have to go to print in the report, not modify, print.  Then push the button PLC I/O Count Summary by PID.  It is the last button to the right.  Then you will see the 1 listed.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34934722
< Then you will see the 1 listed.>  WHERE?
0
 

Author Comment

by:datadigi
ID: 34934742
On the report it is in the last 5 fields that display the 1.  There are 7 pages total.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34934759
modify  the query  QryTagnoSummary
like this one, copy and paste

SELECT PROSEP.TAGNO, PROSEP.PIDNO, PROSEP.FUNCTION, PROSEP.SERVICE, PROSEP.SERVICE2, PROSEP.CALIB, PROSEP.CALIB2, PROSEP.FLOUNITS, PROSEP.DIG_INPUT, PROSEP.DIG_OUTPUT, PROSEP.ANALOG_IN, PROSEP.ANALOG_OUT, PROSEP.RTD_INPUT, PROSEP.RAW_INPUT, PROSEP.V_TOONSPEC, PROSEP.MODBPROTAD, PROSEP.EUI_NO, PROSEP.CUSTOMER, PROSEP.PROJECT, PROSEP.PROJECT_NO, PROSEP.PROJECT_NO, PROSEP.REVDATE
FROM PROSEP
WHERE (((PROSEP.DIG_INPUT) Is Not Null)) OR (((PROSEP.DIG_OUTPUT) Is Not Null)) OR (((PROSEP.ANALOG_IN) Is Not Null)) OR (((PROSEP.ANALOG_OUT) Is Not Null)) OR (((PROSEP.RTD_INPUT) Is Not Null));


after doing that run the report and see if that is what you want.





0
 

Author Comment

by:datadigi
ID: 34934817
Thank you, I will try it!!!
0
 

Author Comment

by:datadigi
ID: 34934877
How do I edit the query?
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 34934910
ok try this


PROSEP-DYPROTEC.zip
0
 

Author Comment

by:datadigi
ID: 34934938
Oh my God!  You are fabulous!!!  You figured it out!
0
 

Author Comment

by:datadigi
ID: 34934947
Can you do a print all reports button on it that prints only the reports that have data in them?
0
 

Author Closing Comment

by:datadigi
ID: 34934998
He is very very good!
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34934999
no, i am afraid not..
please limit your question to one in a single thread.
0
 

Author Comment

by:datadigi
ID: 34935008
Can you make a print all reports button to print the reports that have data?
0
 

Author Comment

by:datadigi
ID: 34935014
Oh, OK.  I understand, one question per thread.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question