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 gkittelson 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: *

  • Users: svoss
  • Order by date
  1. svoss

    Viewing Historical Instances Through ePortfolio

    We are having an issue when trying to view historical instances through ePortfolio. The report we are trying to view is an Aging report, so it measures the amount of time a file has been in process, based upon the current date. The formula takes the CurrentDate - The File Received Date to...
  2. svoss

    Fields not recognized on Spreadsheet import

    I am exporting a report from crystal into excel, and then linking this spreadsheet to an access database. When the report is exported from Crystal, it seems as if the text fields are not recognized in Access unless the exported excel report is opened, modified, and saved. When I go to link...
  3. svoss

    Printing Multiple field values on one row (eliminate duplicate records

    Thank you so much for your help. Here is what I get when I use the code + totext(status) and group on the formula: Acct # Status 1234 ccr3.00 1234 cpm3.00 1234 dat4.00 1125 ccr4.00 1125 cpm3.00 1125 dat3.00 This is what I would like: Acct # Status1 Status 2...
  4. svoss

    Printing Multiple field values on one row (eliminate duplicate records

    Thanks for your response. I did try grouping by acct_nbr and created 3 seperate formulas for each req_cde. I added these formulas to the group header, however the formula only displays the value for the first record listed in the detail section of the group. (I still have 3 records listed in...
  5. svoss

    Printing Multiple field values on one row (eliminate duplicate records

    In our database, we have numerous requirement codes that apply to each acct. number. I want to show the status of certain requirement codes without duplicate records--I want each acct. number to list only once on only one row. I would like the Req. code to be the header of the column and the...

Part and Inventory Search

Back
Top