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!

Register Log in
  • Congratulations Chriss Miller 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: ekr
  • Content: Threads
  • Order by date
  1. ekr

    Updating Pricing in MS Access 2010

    Hello- I have a spread sheet of new prices for 1000+ products. I would like to load these prices into my Access database as a new field (newprice). How do I tell Access to take item number 12345 from the spreadsheet and add "$XXX" to the newprice field? I assume this is an update or append...
  2. ekr

    grouping data and subtotal

    Hello- I am trying to group data points to get a subtotal. I have item numbers with 'suffixes' whose quantities I want included in a subtotal, but not grouped separately by item. For example, item qty 8471 3 8471-1B 8 8471W 4 all should be in group "8471" and show a...
  3. ekr

    Projects in OpMgr.dbf

    Hello- I am trying to create a Crystal Report, extracting 'Project' info from the OpMgr table. I have selected RecType=P for Projects, but they are still not appearing in the report. Goldmine 5.5 and Crystal 8.5 (yes I know I have dinosaurs here.) Any ideas on how to set up a Project report...
  4. ekr

    Calculate a price based on a category

    Hello- My dataset has 500 items, each with a unique price. Each of these items is associated with a category. Based on the category, I want my report to calculate a new price. For example, if the category is A, multiply the price column by 10. If the category is B, multiply price column by...

Part and Inventory Search

Back
Top