Search results

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

The table I'm attempting to get all that data into has the following fields: CName, Dept, Div, PosNum, WeekEnding(Date), NumHours

I am pulling it into a temp table first. Then I run an append query that appends the fields I need, but I can only include one of the "hours" fields because I need the "Date" field to equal that date for only those records. Then the next append query can pull everything but with the 2nd of the...

When I receive the report for the actual hours it comes in a spreadsheet that is already listed as one week per row. So its' very easy to do an import and just append the new records. No problem. But the budgeted hours come as the above spreadsheet attachment indicates. I would love to import...

Obviously I didn't describe the spreadsheet the data is coming from well enough. I've attached a screenshot of one (there are about 20). The columns you can't see to the left are all calculations (things I'll no longer need). And then the dates for the rest of the fiscal year go to the left and...

Yeah, I thought that too. I guess the biggest problem is how to import the currently existing budget forms if I create the fields that way. They are currently in Excel spreadsheets with about 100 columns(including the weeks) and contain fields for calculating monthly and weekly totals, grand...