Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

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

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
datadigi
Asked:
datadigi
  • 13
  • 7
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
a copy of the db will help.
0
 
GRayLCommented:
I don't understand your question.  Please try again.
0
 
datadigiAuthor Commented:
re-posting it with database
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
datadigiAuthor Commented:
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
 
Rey Obrero (Capricorn1)Commented:
how do you determine whether the Tag number should be on the report or not?
0
 
GRayLCommented:
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
 
datadigiAuthor Commented:
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
 
datadigiAuthor Commented:
I will try shrinking the database and then re-posting it.
0
 
Rey Obrero (Capricorn1)Commented:
< It is the 1, listed on everything>  where do you find the "1"? on what field?
0
 
datadigiAuthor Commented:
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
 
Rey Obrero (Capricorn1)Commented:
< Then you will see the 1 listed.>  WHERE?
0
 
datadigiAuthor Commented:
On the report it is in the last 5 fields that display the 1.  There are 7 pages total.
0
 
Rey Obrero (Capricorn1)Commented:
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
 
datadigiAuthor Commented:
Thank you, I will try it!!!
0
 
datadigiAuthor Commented:
How do I edit the query?
0
 
Rey Obrero (Capricorn1)Commented:
ok try this


PROSEP-DYPROTEC.zip
0
 
datadigiAuthor Commented:
Oh my God!  You are fabulous!!!  You figured it out!
0
 
datadigiAuthor Commented:
Can you do a print all reports button on it that prints only the reports that have data in them?
0
 
datadigiAuthor Commented:
He is very very good!
0
 
Rey Obrero (Capricorn1)Commented:
no, i am afraid not..
please limit your question to one in a single thread.
0
 
datadigiAuthor Commented:
Can you make a print all reports button to print the reports that have data?
0
 
datadigiAuthor Commented:
Oh, OK.  I understand, one question per thread.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 13
  • 7
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now