Search results

Correct - the score value is an average of all the scores relating to that control - so I do not want to duplicate the same score multiple times for the control, and only want it to show one time (instead of displaying however many ASDx there are for that control).

Switched it to that and did not see an error in Design View, but when I switched to Form View I got a #Name? error for each record, with the same amount of rows as before ):

Oh great! Here is the code I am using for the text box and getting an error: SELECT DISTINCT ControlID, SimpleCSV("SELECT ASD FROM Pivoted_Data_Query WHERE ControlID=" & [ControlID]) AS ASDs FROM Pivoted_Data_Query I am trying to group by ControlID, which is a short text field.

I'm trying to display the results of my form with the concat function. My form's recordsource is currently the "Pivoted_Data_Query" so it displays the results of this query using the combo box filters on the form to set the where clause of the query- I would like to concat the results of this...

It is sensitive information, so I don't think I can post it unfortunately. If I didn't explain my use of it well enough in the original post, what else can I tell you that might help? Sorry for the inconvenience!

How so?

Yes that sounds right! Basically have a form that is setting the WHERE clause for the initial query, and then created a second query to essentially use Allen Browne's function to concatenate the results from the first query. Okay I'll look into the parameters of the initial query - is there a...

I'll look into that - the reason that we are using a form though is because we want to display the results of the query in a nice format which we hthought a form would be best form. So, is there a way to implement while still using the form?

Thanks! And thanks for the reply. Are you referring to converting the parameters set by the form in the first query? -- Also I tried using the simple function earlier today but could not find out how/where to implement.

Hi -- need some help ASAP!!! Also, sorry for the long post... if you're looking for the main code/issue please skip to the bottom of the post. I've read an endless number of forums relating to this issue over the last week trying to figure out my problem, but have not had any luck applying the...