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 derfloh 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. jpl458

    Sort a string and remove duplicate entries

    ck1999: I have to sort the data with each row. I doing something like an SQL group by where the ouput data is a summary of the input data. There may be 20 entries for a company and the states they are in, and I had to reduce it to one entry for the company, but have all the states they...
  2. jpl458

    Sort comma separated values in string

    Pivot tables will not work for this solution. I use big pivot tables every day. IN Pivot tables I can count the states or sum the states. I can't display the states. I put the data in memory in an array and process it into another array, and part of that process is concatenating two "Field"s...
  3. jpl458

    Sort comma separated values in string

    Skip: In the data in the worksheet each row represents an entity that has locations in states. Many of those entities have the same name but have different states. My task is to do a Group By where there is only one entity name, but have all of the states for all the entities in one column in...
  4. jpl458

    Sort a string and remove duplicate entries

    The concatenation is what causes duplicate. There are no duplicates prior to the concatenation. jpl
  5. jpl458

    Sort comma separated values in string

    Skip, the concatenation is what causes duplicates and thanks for sending me to the right place. Strongm I get the data in a workbook with one sheet that contains the original data. Some 10,000 rows. I am doing, in SQL parlance, a Group_By on company name. Iwill have two sheets at the end, one...
  6. jpl458

    Sort a string and remove duplicate entries

    Writing a data conversion app that concatenates groups of two digit state codes and is written in ECXEL vba. I redd the data into an array and output what I need to an output array Rout, and when done write the result to a worksheet. There is one column that I would like to sort immediately...
  7. jpl458

    Sort comma separated values in string

    Writing a data conversion app that concatenates groups of two digit state codes and is written in ECXEL vba. I redd the data into an array and output what I need to an output array Rout, and when done write the result to a worksheet. There is one column that I would like to sort immediately...
  8. jpl458

    Putting result of formula in another cell

    I want to compare two cells in an excel spreadsheet and if they are the same I want to concatenate two cells and put them in the cell different from the formula location. Example =IF((B2 = B3),R3=CONCATENATE(G2,G3),"") I tells me false. Windows 7 Office 10 Thanks in advance jpl
  9. jpl458

    Problem with Like operator

    I have simplified the LIKE to Like "GP4*" and it returns: PEMP GP4_1/2H GP4_1/2H GP4_1/2H GP4_1/2H DOGEV GP4_1/2H GP_IMP-A GP4_1/2H GP4_1/2H GP4_1/2H GP4_1/2H GP4_1/2H GP4_1/2H GP_IMP-A GP4_1/2H GP4_1/2H GP4_1/2H GP4_1/2H GP_IMP-A GP4_1/2H GP4_1/2H GP4_1/2H GP4_1/2H GP_IMP-A DOGEV, Plus other...
  10. jpl458

    Problem with Like operator

    Correction, the database is a Progress Database and the column in question is text. jpl
  11. jpl458

    Problem with Like operator

    ...I only want to look at the following codes in that column: GP4_1/2H GP4_1HR GP4_1H_F GP_IMP-A GP_IMP-J My Like clause is the following: Like "GP4_*" Or Like "GP_*" I get back all the right things but also get back: GR10 XR10 FRMONE FNYI DOGEV, Etc Read up on wildcards and like, but can't...
  12. jpl458

    Problem constraining query on alias

    I was confused, and was cross-talking two fields. It was just pilot error. Sorry for taking your time. Thanks jpl
  13. jpl458

    Problem constraining query on alias

    Here is the complete SQl. SELECT [PUB_PSHISTOR]![PSH-Date] AS RDate, Format([PUB_PSHISTOR]![PSH-Time]/86400,"hh:nn:ss ampm") AS RTime, "Fee" AS RndType, PUB_PSHISTOR.[PSH-TC], CStr([PUB_PSHISTOR]![PSH-TC]) AS RCode, [PUB_PSCODES]![PSC-PrtDesc] AS RCDescription, " " AS TnNumb...
  14. jpl458

    Problem constraining query on alias

    I need to constrain a query based on the alias that I created for a column. I have one that works and another that doesn't. The following works: RDate: [PUB_PSHISTOR]![PSH-Date] is in the line of the QBE Grid #7/17/2014# is in the criteria line for the above and it works fine. neither of the...
  15. jpl458

    MSExchanges not rejecting bad email addresses

    I have written a specialized email application In ACCESS 2010 for my department. At first I couldn't send email outside our domain so the server folks turned on relay and gave me a static IP address. However, now the mail server does not reject bad email addresses unless I leave off everything...
  16. jpl458

    Updating a general time field in table

    Skip, it did the trick. I had to muddle trough some fat finger issues. Thanks a lot. jpl
  17. jpl458

    Updating a general time field in table

    Its DateTime formatted in the table as General Date. Just tried DoCmd.RunSQL "UPDATE LastEmailUpdate SET LastEmailUpdate.lastEupdate = #" & Now() & "#" No joy. I even tried changing the table def to text with: Dim Testfield As Date Dim Textfield As String Testfield = Now() Textfield =...
  18. jpl458

    Updating a general time field in table

    Only one. It tells me the time of the last update, and I use it to update only transaction that are past that date. I have looked at Time stamping but that saves the time of every transaction. As I said it works perfectly in MDB but not in ACCDB. I just tried up dating using the following...
  19. jpl458

    Updating a general time field in table

    BTW I am using office 10 and windows 7. jpl
  20. jpl458

    Updating a general time field in table

    I have an older program that uses the following: DoCmd.RunSQL "UPDATE Last_Update_Date SET Last_Update_Date.LastUpdate = Now()" It works perfectly. But the old app is MDB I have a new app That is accdb that uses the following: DoCmd.RunSQL "UPDATE lastEupdateTbl SET lastEupdateTbl.LastUpdate =...

Part and Inventory Search

Back
Top