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

    Need help in identifying potential item shortages

    Qty needs to be accumulated, once the Accumulated Qty hits a minus number, thats what I need to know. The records are ordered by reqdate, when the accumulated qty goes negative I need the reqdate of the item that goes negative, this tells me the date the item is shceduled to go negative. I...
  2. JeffMachine

    Need help in identifying potential item shortages

    I have data from a manufacturing system and each row represents a transaction. I need to know when an item is scheduled to go negative and the next scheduled replenishment date and amount after that. Sample data. Data is not stored in order, will need top be sorted by itemid,reqdate...
  3. JeffMachine

    Link to the exchange rate table

    I have various sales and orders queries that I must now link to a currency table to convert to USD. The currency table looks like this: currency fromdate rate USD 1900-01-01 78.44 USD 2006-08-31 77.839 USD 2006-09-30 79.001 USD 2006-10-30...
  4. JeffMachine

    I need to modify my inventory valua

    Couldn't figure out how to edit the original post, but the last column of the subreport should read 3 not 2 for the qtyonhand. Thanks ...
  5. JeffMachine

    I need to modify my inventory valua

    I need to modify my inventory valuation report to show the newest and oldest date an item has been in inventory. I've added a subreport that selects all receipts for each item. I've passed the qtyonhand to the subreport for comparison. I've ordered the subreport by transaction date descending...
  6. JeffMachine

    linked server, error 4064

    This seems to have taken care of it: EXEC sp_addlinkedsrvlogin 'pcisv002', 'false', @rmtuser = 'report', @rmtpassword ='report'
  7. JeffMachine

    linked server, error 4064

    I figured out to do this for one user. If I run this command I can get it to work for jsmith: EXEC sp_addlinkedsrvlogin 'pcisv002', 'false', 'domain\jsmith, 'report', 'report' What would be the same command but that would work for all users? I don't want to have to run this for every current...
  8. JeffMachine

    linked server, error 4064

    Thanks for the response Frederico. I'm not sure that's the issue though. If I remove the part of the query that accesses the linked server (it is a union query with the second part hitting the linked server) the users can run the report successfully. They just don't get any data from the...
  9. JeffMachine

    linked server, error 4064

    I created a query that links 2 servers (used sp_addlinkedserver). I used this query for a Crystal report. Works fine if I run the report. I assume because I have admin rights. My users get a 4064 (failed to retrieve data) error code when running the report however. Any ideas on how to get...
  10. JeffMachine

    Assign "Language for non unicode programs" setting by user

    We have a 2008 ru2 Terminal server that serves two user bases, one in China and the other in India. The Chinese have a application for reporting taxes that needs to have the system locale (control panel/region and language/administrative/language for non unicode programs) set to Chinese...
  11. JeffMachine

    Rounding price increase to the nearest

    We are increasing our prices by 4% (price*1.04) and I need to write a query to show the sales dept. what the new prices would look like and I need a little help with the syntax to calculate the new rounded prices. We would like to round these new prices based on the table below: Price...
  12. JeffMachine

    Need help with a Vlookup formula

    Thanks Gruuuu, your formula worked perfectly. Skip, thanks for the info on the TGML tags, I'll check them out for the next time.
  13. JeffMachine

    Need help with a Vlookup formula

    I need help creating a formula that will add column B to the sum of D where column A = column C. Column C can have multiple entries for column A so a sum is needed in the vlookup. There might not be anything in C for every A. C and D would be used as the table array A B C...
  14. JeffMachine

    Indentify second occurance of a character

    Thanks Markros and GM, all are good suggestions. I used Markros statement since it worked perfectly for me. Thanks ....
  15. JeffMachine

    Indentify second occurance of a character

    I have a field whose data looks like this: 003391 003391-01 003391-01-01 002498-02-01 004895-02 004895-02-01 005523-01 I would like to have a query that returns "Warranty" for lines 3,4 and 6 and nothing for the others. Warranty items end in "-01" but only after the second dash. So lines 2...
  16. JeffMachine

    Need to add a total valuation column to a crosstab

    I have created a crosstab report that shows each item and the quantity of that item in each warehouse along with the total of all warehouses. whse1 whse2 whse3 total item1 1 2 6 9 item2 0 3 2 5 I would like to add the item's description as a...
  17. JeffMachine

    how to add days to the due date

    Thanks crystalreporting, that worked perfectly.
  18. JeffMachine

    how to add days to the due date

    I need to update the data.

Part and Inventory Search

Back
Top