Recent content by jpl458

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

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

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

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

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

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

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

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

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

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

Have a column in a table that contains various codes but 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...

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

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

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

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