Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rbescos

    Omitting Records

    That is just what I needed. Works great!! Thank you!!
  2. rbescos

    Omitting Records

    I’m trying to come up with a way to omit records from my report. Each record has four dates we need to track. I only want to display records that are missing all four dates or only one of the four. I would like to omit the records that have all four dates in the fields we are tracking. Any...
  3. rbescos

    Split address number from address name

    Perfect.. This is just what I needed.. Works great!!
  4. rbescos

    Split address number from address name

    I need to separate the street number from the street name in to two different fields on a report. Any assistance would be greatly appreciated.
  5. rbescos

    Excel (data only) Display Strings fail

    TeyBrady, Thanks for the tip. I'll try it on my next report I need to get done next week. This should allow me to export data only without having to worry about alignments so much. Robert
  6. rbescos

    Excel (data only) Display Strings fail

    It took a while with 85 feilds but I finally got it done. Thank you very much for your assistance. It was greatly appreciated. Have a great weekend!! Robert
  7. rbescos

    Excel (data only) Display Strings fail

    When I use the regular report I get an extra blank row between all my data rows. I haven't been able to figure out how to align the fields to eliminate this. I was able to eliminate the extra columns by aligning the lefts in the details and headers.
  8. rbescos

    Excel (data only) Display Strings fail

    I have a few fields that are edited with a display string. The report looks fine when I preview it. When I try to export it to Excel (data only), the display formula fails. Am I missing a setting or does this not work with Excel (data only)? Here is one of the formulas I'm using. if...
  9. rbescos

    Returning different value

    Thank you kray4660.. It works perfect!!
  10. rbescos

    Returning different value

    My table has a field called "Reside_Type" which will currently return one of three values. I'm trying to get the report to return one of three numbers instead. "Primary" should return "1" "Secondary" should return "2" "Investment" should return "3" Thank you in advance
  11. rbescos

    Highlighting Formula

    It works like a charm!! Thank you so much for your help!!
  12. rbescos

    Highlighting Formula

    It's not within a crosstab. I'll plug it in and see.
  13. rbescos

    Highlighting Formula

    Thank you for the quick reply. I think this will highlight if the submission date is null even if I'm within the 20 day time period of the toprocessing date. I need the row to highlight if the submission date is null 20 days greater than the to processing date. Thanks again.
  14. rbescos

    Highlighting Formula

    I’m trying to come up with a formula or a way to highlight a date field. The two fields I am comparing are a “To Processing Date” and a “Submission Date”. I’m trying to get the row or processing date to highlight if the submission date is null (no date input) for >= to 20 days. Any help would...

Part and Inventory Search

Back
Top