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!

Recent content by egghi

  1. egghi

    Search engine

    Thank you so much! I will give it a try and let you konw if it works!! Thank you, thank you, thank you!
  2. egghi

    Search engine

    Hi, I have a simple ACCESS (ACCESS 2000) form which allows users to search the table by setting 1 or multiple of the 5 different parameters (i.e. customer name, order date, order ID, customer phone number, product name). Some of the parameters use a drop-down menu, and some allow users to...
  3. egghi

    Move from row to column

    Happy Friday! I am having some hard time with a query I created... My current query: SELECT Code.h_codeid,Code.h_instance,Code.h_code,Code.h_date FROM Code INNER JOIN Account ON Account.SSAccountID=Code.SSAccountID AND Account._counter=Code.claimlink WHERE Code.h_codeid IN ('DI','PR')...
  4. egghi

    Monitor queue on a communication PC

    Hi, We use a communication PC to connect to one vendor's system for cost reason. Sometimes, when end users call the procedure, the PC would try to query and build up a long queue since no results are returned. The wait counter would just keep running. Is there a simple way to monitor the...
  5. egghi

    Count MAX(BillDate) WHERE PostDate = BillDate - 1

    Bingo!! I think we have it!! I can't thank both of you (genius!!!) enough:) Thank you, thank you, thank you!! You deserve many stars!! Egghi
  6. egghi

    Count MAX(BillDate) WHERE PostDate = BillDate - 1

    Hello George, I ran your query and got an error message... Server: Msg 8118, Level 16, State 1, Line 1 Column 'MyTable.counter' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause. Any idea how we can modify the query? Thanks a...
  7. egghi

    Count MAX(BillDate) WHERE PostDate = BillDate - 1

    Hello George and Borislav, I tried Borislav's query and it got REALLY REALLY close to what I want! I validated the result with the data on the table, and there are two problems left! The first problem is my fault... PostDate does not always have to be BillDate - 1. As long as the order is...
  8. egghi

    Count MAX(BillDate) WHERE PostDate = BillDate - 1

    Hi George, Sales rep gets credit based on the post date AND IF the order posted is successfully billed in later days. So, Alice gets a credit when order was re-posted on 9/25 and then successfully re-billed on 9/26. Basically, the query needs to find the last billdate for each order and then...
  9. egghi

    Count MAX(BillDate) WHERE PostDate = BillDate - 1

    Hi, I am not sure if this can be done, but I sincerely hope someone can help me out. I have a table with data like this: counter salesrep PostDate BillDate -001234 Adam 2006-9-23 00:00:00 2006-9-24 00:00:00 -001234 Alice 2006-9-25 00:00:00 2006-9-26 00:00:00...
  10. egghi

    Split rows in Excel

    Hi Skip, So, I created two queries. The first one is called splitrow(1): SELECT [PRODUCT CODE], DESCRIPTION, [CATEGORY], PRICE,[Modifier 1] AS [MODIFIER] FROM products WHERE [Modifier 1] IS NOT NULL UNION SELECT [PRODUCT CODE], DESCRIPTION, [CATEGORY], PRICE, [Modifier 2] AS [MODIFIER] FROM...
  11. egghi

    Split rows in Excel

    Hello Skip, I was really dumb... I was too focused on vbscript and totally forgot about the power of SQL query! One last thing to bug you: if I do have more than 2 modifiers (say I have 3 modifiers), should I create 2 queries? The first one is modifier 1 union modifier 2, and then the second...
  12. egghi

    Split rows in Excel

    Hello Skip, Thank you very much for the input! The problem with union is that I cannot have more than 2 modifiers. Also, if Modifier 1 is null and modifier 2 has a value, the union query would return a repeated row with no value in Modifier: Procedure Description Category Price Modifier1...
  13. egghi

    Split rows in Excel

    Hi, I am trying to split rows in an Excel spreadsheet. My spreadsheet currently looks like this: Procedure Description Category Price Modifier1 Modifier2 001234 Plastic bag V $12 TC890 TC990 001235 Paper box V $15 TB003 001236 Tin can J...
  14. egghi

    Macro for FIND & REPLACE file names within the macro

    Hi, I need to write a VBA function that allows users to find specific text in the macro and replace the text with a new text without using the FIND & REPLACE feature in Excel. The macro I wrote imports file with names like filename08072006.txt. I am trying to create an form that allows users...
  15. egghi

    how to build a SQL simulation tool quickly?

    Hi, I am trying to build a SQL-based simulation tool which will apply complex rules (rules stored on a rule table) to different scenarios. The logic is to throw all the rules onto a rule table, and then create a form which users can enter a scenario (i.e. 21-year-old driver with no DUI record...
See more

Part and Inventory Search

Back
Top