Recent content by pfuesting

I have no code to do this.

Thanks for the response, that works great, but there is only one problem. It errors when only 1 record has a value. How can I change it to only look at the records when it is >1?

Thanks for the response, but I am hoping to find VBA code that would be able to do this without all the complex queries.

This is not a one time thing and would need to be repeated. Therefore it has to be automated in Access for the users. This information will be used to display on a report and has to be parsed out.

Sure, here is the data: v1 v2 case number Group 1 PT1, PT2, PT3 123 Group 1 PT4, PT5 125 Group 1 PT5,PT6 124 Group 2 PT7 126 Group 3 PT8 127 It doesn't really look that different. I am justing counting the number of case numbers...

I have a query in Access that is producing this: V1 V2 Count Group 1 PT1, PT2, PT3 1 Group 1 PT4, PT5 1 Group 1 PT5,PT6 1 Group 2 PT7 2 Group 3 PT8, PT9 1 But I need it to create a new record for the comma separated values. The data should look like this: V1 V2 Count Group 1 PT1 1 Group 1 PT2 1...

Please help....I am trying to calculate the median based on a grouping. I am using the following code and it seems to be working. The only probelm is that there are also null values that should not be considered. How do I exclude the null records from the record count? Function...