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 wOOdy-Soft 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: calpolymis
  • Content: Threads
  • Order by date
  1. calpolymis

    Can anyone help with this simle calculation? I can't verify my answer.

    If you can print 22500 pages with 7.5% coverage on one page with an ink cartridge, how many pages can you print with 5% coverage?
  2. calpolymis

    Calculating desired profit margin depending on our cost

    Hi, I need to develope a macro for Excel to calculate desired profit margin depending on our cost. Here's the scenario. A1: landing cost If 0 <= A1 <= 2, then multiply 200% to A1 and write the target profit margin on B1 If 3 <= A1 <= 5, then multiply 150% to A1 and write the target profit...
  3. calpolymis

    change field background color in report based on text

    Hi. I want to change the background color of "item" field on Aceess report to yellow, if it contains text "special editoin."-without case sensitivity. How would I do this? Conditoinal formatting only enables number values, not text. Thank you for your help.
  4. calpolymis

    Connect a wireless router to windows 2003 server network

    Hi. I have a wireless router connected to our win 2003 network. Rough diagram is internet-> Linksys router -> wireless router & server -> switches The wireless router's IP is setup as part of our network (given static IP, subnet, gateway, and DNS) It's...
  5. calpolymis

    How to sort numbers+space+letters combination by letters?

    Hello. I need to sort a column with combination of numbers(sales order#,) a space, and letters(category ID.) The current column is sorted by numbers and looks like this: 81000 WARRANTY 81001 WARRANTY 81002-A DLR 81003 DLR 81004 EXPORT 81005-A EXPORT I need to sort the column in the following...
  6. calpolymis

    Different price per dealer

    Hi. I have a database based on the structure of Northwind sample database, that is one price per product in the product table. Recently the requirement has been changed, and I need to have multiple prices per product for different dealers. For example, product A sells for $10 to dealer A, but...
  7. calpolymis

    Caculating Totals by groups with a number field

    Hi. I have a tblorder and tbldetail, 1 to many relationship. tblorder has order A, B, C... and each order has detailed items in tbldetail for example CD1, CD2, CD3... Each item has a number field named Qty for order quantity. I'm wondering if I can add up the Qty field by items or get a total...

Part and Inventory Search

Back
Top