NeoPa - the 255 character limit is what caused my truncation problems. For this project, the excel macro is how I finally was able to complete the job.
Thankfully (I guess?), I haven't had as much of a complex need for data management. Thanks again for all the help a couple of years ago and it looks like this may have help a few others over time!
kyjabber
Last Activity: Apr 27 '09, 07:46 PM
Joined: Jan 18 '07
Location:
-
Thank you.... I appreciate all the help! I'll probably post any other solutions, if that's fine, b/c I like to keep stuff in the same place and since I had a hard time googling any solutions, I'd like to share them.Leave a comment:
-
Not sure, I *think* it's characters, but I haven't looked at that.
My friend (since he knows actually what he's doing at this point instead of me muddling) did some other changes to do the list like I was talking about. I've got to go look at all that (just got the email). I'll post that, too.
If you want on the SQL part, i can post what he said as to why with the "Last" worked.... I haven't had time to...Leave a comment:
-
Except, now..... not all things in the list are coming up. Field size limitations? It looses some of the list. :|Leave a comment:
-
A buddy of mine took a look at the SQL (with database in hand)
He came up with this:
And it worked.......Code:SELECT t_CompanyCategoriesProducts.CompanyName, t_CompanyCategoriesProducts.Category, Last(Concat([CompanyName] & [Category],[Product])) AS Products FROM t_CompanyCategoriesProducts GROUP BY t_CompanyCategoriesProducts.CompanyName, t_CompanyCategoriesProducts.Category;
Leave a comment:
-
Thank you! I will keep trudging away!!!! :)
I here you there.... I'm going to test and see if my system is back stable (it wasn't doing all this when I started LOL)... if not try it tomorrow on my work system.
Thank you again!!!!! And I'll report back once I get to work on it again. I know I'm the only one that's looked for this and hopefully my experience can help someone else....Leave a comment:
-
Correct me if I'm wrong, but I should just have to run the query?
The message that comes up when I go to run the query is
"Reserved error (-1038); there is no message for this error."
Just so you know, I'm having some other computer problems today, that shouldn't be related, my video card drivers are X( corrupted or card is dying. Working to rectify that (it rains it pours. LOL) since my computer...Leave a comment:
-
Note, these are not working... and I can't figure out how I got them to work that one time.
LOL at teh expert... I just wish it sunk in a little easier. My IT dept gets intimated by what I do know (they know if I call I'm in a tough spot but they call me for help... WTF gives, ya know?). and it's frustrating b/c my director is approving me to go to classes (and wants me to learn this stuff) but somehow the IT director can veto that...Leave a comment:
-
With the SQL as you have listed somehow I got it to run once, (but now I"m getting an error, of course I'm doing this at home and it's Access 2000 on XP rather than Access 2002, but really shouldn't matter)
When it did run, the products where not combined, but it did only list a category per CompanyName (Say a CompanyName has fruits, vegetables, and organics it listed:
...Code:CompanyName Category Product
Leave a comment:
-
Awww, thanks NeoPa! You rock.
Yesterday, I added the (that I found someplace on the web and fixed for my needs) Macro below to Excel:
...Code:Sub Combine() Dim J As Integer If Selection.Cells.Count > 1 Then For J = 2 To Selection.Cells.Count Selection.Cells(1).Value = _ Selection.Cells(1).Value & ", " & _Leave a comment:
-
I'm not sure how to post attachments. Sorry to be such a n00b!
Here's what I got in the module thus far, but I know I don't all three fields represented and I hadn't figured it out yet (was looking for examples and reading to know what I was doing... )
I don't know what to do with the field Category yet.
...Code:Option Compare Database 'Concat Returns Products 'listed by company Public Function
Leave a comment:
-
How would you suggest with formulas? each Company has a different of products and category mixes and a number of records?
What I posted was an exert of a query that does contain data from three different tables (one is a pass through table that give the product its ID).
I can post an excel file that shows the results of the query and what I've done by hand. I just *know* there has to be an easier (and quicker way) to...Leave a comment:
-
We'll... I've never been afraid to learn. I've seen several VBA and SQL scripts accomplishing something and I'm trying them out, but no luck so far.
The excel Macro is annoying b/c I have to select each section and I have over 350 companies to go through and 3K products collectively.
Thanks away, but I'll take any suggestions that I can get.
~Anna...Leave a comment:
-
Yes, this is for display purposes/export to Excel. I'm having to generate this for another function to a contracter. My other option was to hand merge them in Excel with a macro.
Unforunately my coding is very rusty, and I'm not very experienced in SQL or VBA. (Want to learn but manager won't send me to training :|, well he woudl but our IT staff won't approve.long story.)...Leave a comment:
-
Combining Multiple Rows of one Field into One Result
I have a multi relationship database and I'm pulling the company's contact info, queryied if they are a grower, and a resulting list of their products by catgeory. I need to have the products listed all together in one field.
Example:
...Code:CompanyName Grower Category Product B Orchard -1 Fruits Apples B Orchard -1 Fruits Blackberries B Orchard -1 Vegetables Beans B Orchard -1 Vegetables
No activity results to display
Leave a comment: