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. Randygk

    Software Licensing

    MS Windows 2k advanced server per seat license, MS Office Pro 5 seat license, MS SQL 2000 25 seat License, Computer Associates Innoculate IT 25 Licenses, Computer Associates Arc Serve Open License, Computer Associates Arc Serve SQL DB Backup, Computer Associates Arc Serve MS Exchange Backup...
  2. Randygk

    Software Licensing

    If we sell a company off to another party and we purchase our servers back from them. Who has the rights to the software licenses are they licensed to the server or to the company which in name no longer exists? They include several Microsoft products and Computer Associates, Crystal
  3. Randygk

    Report Faxing

    I currently have a report written that prints out request for quotes for the same item to several specified vendors these vendors are specified within my Dbase. Each vendor has its own page within this report with our name address phone and fax numbers along with the vendors information. I am...
  4. Randygk

    I am running Crystal Reports 8.5 wi

    That looks like it is working I had the wrong table for the cust_id Thanks all for your help
  5. Randygk

    I am running Crystal Reports 8.5 wi

    I tried that when I save the selection criteria I get an error "The summary / Running total field could not be created.
  6. Randygk

    I am running Crystal Reports 8.5 wi

    I am running Crystal Reports 8.5 with a SQL 2000 database. I am trying to return the date of the last order for each customer id number and then compare it to current date and show it only if it is older than 180 days. order_no order_date customer_id 102005 12/24/2002 10002584...
  7. Randygk

    Selection Formula

    But on item 30985 first entry it is a C disposition and 0 shipped and the second entry 10 were shipped I don't want the first entry to show up since they were shipped on the second entry. so in this case neither of the item 30985 would show up on the order.
  8. Randygk

    Selection Formula

    I need a formula to look further to see if the same item exists in an invoice. I am extracting items which have been backordered or cancelled, if an item has been cancelled I need to look further on the order and see if it was reentered on another line if it was I do not want it to show on the...
  9. Randygk

    Duplex printing

    Found the problem to be a corrupt page toward the beginning of the file not included in pages being printed. It threw off all the pages by 1 page. so the page that should have been on the backside of one sheet was on the front of it's own sheet.
  10. Randygk

    Duplex printing

    We have PageMaker 6.5 and have printed duplex documents in the past out of this file and all that was done was we opened the file made a change to a certain page and now it will not print on the backside of the previous page. two sided printing is set in Document settings. Help!! Randy
  11. Randygk

    Printing details

    Is there any way to reprint Group Header #2 on a second page if the details overflow onto a second page.
  12. Randygk

    Column Totals

    I am trying to write a gross Profit Report with the following info on it Date, Order#, Customer Name, Gross Amt, Sales Tax, Freight, Discount, Cost of goods sold, and Net Amt.. My problem is that my cost of goods sold is spread across several lines as it is attached to each item. What I am...
  13. Randygk

    active directory

    Has anyone come up with a way to save favorites under Internet Explorer when running mandatory profiles.
  14. Randygk

    String conversion to numeric

    I found that the items in question were non stockable items which was another column in the same table so I was able to filter on this column. Thanks
  15. Randygk

    String conversion to numeric

    I have an Item_id field that is a string field I would like to filter off all Item_id's with any characters other than numbers and then change this field to a numeric one so I can sort numerically by item_id. Thank You, Randy
  16. Randygk

    Division by 0 Error

    If standard_cost <> 0 then price8/standard_cost else 0
  17. Randygk

    Division by 0 Error

    When I enter that formula I receive the error &quot;A number, Currency amount, Boolean, Date-Time, or string is expected here.
  18. Randygk

    Division by 0 Error

    I am trying to create a formula whereby I divide one field by another. In some cases the field used as the denominator must be a 0, because I get a &quot;division by 0&quot; error. I want to create a statement that would state (If standard_cost <> 0 then price_8/standard_cost else ??????). Can...
  19. Randygk

    Drawing/Text toolbar

    I Cannot expand the drawing/ Text toolbar, all I have is a little Icon I cannot drag it larger and when I click on it I get Adobe Photoshop online update. How can I expand this toolbar? Thanks, Randy
  20. Randygk

    Filter by 'not' statement

    That worked GREAT!! Thanks!!

Part and Inventory Search

Back
Top