Search results for query: *

Hi JoeAtWork, Another thing I forgot to mention is that each record is a separate form and some of the values in TotalSavings are zero and others greater than zero therefore I only want it to print the label and text box value on the forms where TotalSavings > 0 and the others should not print...

Hi Joeatwork, Thanks for the quick help. I took of the code marked in red and placed it on current in the form...the form displays correctly on screen but when printing it does not print either the zero value or if > 0. Any other help you can offer would help tremendously! Display When = Always...

Thanks dhookom! I tried doing a report but keep having the same problem! Using the same code: ( tried it on On Open, On Page and on Activate for reports and On Current, On Open, After Update, etc)... If TotalSavings > 0# Then Me!Label654.Visible = True Me!TotalSavings.Visible = True Else...

Thanks for the quick reply dhookom! I tried the screen only and print only text boxes...it did not work. I am printing bills for town taxes...On my form if the Total Savings > 0 than I want the label and amount to be visible and print on the bill...I get the amount from the table. Control...

Hi, I have a form that gets data from a table and i print these forms (about 3000). There is one field that i only want to print if the value is > 0. I have used If TotalStarSavings = 0 Then Label654.Visible = False TotalStarSavings.Visible = False Else Label654.Visible = True...

Thanks Ken Hamady! Is there any way to just export the formatted report, maybe not to just MSAccess but as a text formatted. Thanks, NeilCh

Hi! I am trying to export a report from Crystal 8.5 to MSAccess. Every section is surpressed except the GF and those are the records that I want exported. However, in the Access table the extra records show up plus the summary records. I have two records for 1 person that are summed up in the...

Thank you Bob Suruncle...Everything worked great. NeilCh

Bob...you're the best...everything worked fine...just one more thing...there are two dept. numbers associated with this person and i want just the dept number from the first row to display right now it is diplaying the number from the second row..everything else is working great. thanks, neil77

I have a retirement report in crystal 8.5...one person in that report has two entries...i need to combine(add) some entries such amt for retirement, days worked, etc but leave the ss#, retirement# , dept number the same as the first row for this person. Need to print this one row only. Any...