Recent content by kvar

No idea what I changed, but it's perfect now! Thanks again everyone! SELECT CopyOfSkus.MDTRegionalCFN, ConcatRelated("[Region]","CopyofSkus","MDTRegionalCFN= '" & [MDTRegionalCFN] & "'") AS Regions FROM CopyOfSkus;

This is just a report I received in Excel and I just need to combine the records to make the report look better. It's a one time thing so that's why there aren't separate tables or a whole database. Using the query Minty posted gives me nothing in regions, just all blank. I did discover taking...

DBGuy, that works. Thank you for the solution! However it seems odd that you would have to make a select distinct query and then pull the data from that. I can't see a reason why you can't just pull from the table directly. I guess it doesn't matter as long as it works, just irritates me I...

The database is attached.

Spaces were just for the post to make it easier to see. The following takes about 3 minutes to run and "Regions" is just blank for every record. SELECT DISTINCT CopyOfSkus.[MDTRegionalCFN], ConcatRelated("[Region]","CopyofSkus","MDTRegionalCFN= ' " & [MDTRegionalCFN]&" ' ") AS...

This gives me syntax error missing operator and highlights the " ' " at the end. SELECT DISTINCT CopyOfSkus.[MDTRegionalCFN], ConcatRelated("[Region]","CopyofSkus","MDTRegionalCFN= ' " & [MDTRegionalCFN]" ' ") AS Regions FROM CopyOfSkus;

When I add the quotes back as we had them I get the syntax error missing operator again and it highlights the last set of quotation marks. The " ' " part.

I'm not sure what you mean. Should I replace the " with '?

I was missing a comma! Thank you. Progress I think, now I get an error that says Data type mismatch in criteria expression. SELECT DISTINCT CopyOfSkus.[MDTRegionalCFN], ConcatRelated("[Region]","CopyofSkus","MDTRegionalCFN= " & [MDTRegionalCFN]) AS Regions FROM CopyOfSkus;

SELECT MDTRegionalCFN ConcatRelated("Region","[Copy of Skus]","MDTRegionalCFN = '" & [MDTRegionalCFN] & "'" ) FROM CopyOfSkus; Same Syntax Error: Missing Operator

I'm using Allen Brown's ConcatRelated function. In my query I get a syntax error for a missing operator. I have tried every possible combination of quotation marks, brackets, single quotes etc imaginable and can not seem to get it to work. I got incorrect results with a couple of my attempts but...

Thank you, while I play around with that for a minute, see if this gives you any ideas. What if I use a spreadsheet, design it like a template. In the VBA OnOpen, have it go to Access and copy a PivotTable that displays like I need, then have it Paste Special - Values into Excel. This way it's...

I'm wondering if there are any other ways, besides a crosstab query or pivot table, that I can have one of my fields as a "column header" and still be able to update data? At the moment I'm contemplating a form where users can update their budgeted hours for each employee. In my table I have a...

Dim WeekEnd As Date Dim FieldNum As Integer Dim selField As String Dim strInsert As String Dim strUpdate As String Set db = CurrentDb FieldNum = "104" WeekEnd = #10/4/2015# With CurrentDb For FieldNum = 104 To 130 selField = "F" & FieldNum & "" strInsert =...

I think I may have gotten an idea to save me a little time writing code/queries. Set a variable for the date and a variable for the first field number that contains hours. So initially they would be 10/4/15 and F104. Then use a loop. I would only have to write the SQL for the append query once...