Search results

Thanks a bunch. This seems to work for the function: Option Compare Database Function ExtractSerialized(InputValue As Variant) As String Dim SplitArray As Variant Dim SplitArrayUB As Long Dim n As Integer InputValue = Nz(InputValue, "") If InputValue = "" Then...

Galaxiom, Would I add something like this to the function? Thanks. Dim varVariant As Variant varVariant = Null Debug.Print Nz(varVariant) 'returns a Zero length String Debug.Print Nz(varVariant, "Null") 'returns the String Null

JANR, I get a "wrong number of arguments used with function in query expression" error.

How would I add this coding to the field if I am already running the ExtractSerialized function from above. Here is a call I am using in a query I have: Activities_Use: ExtractSerialized(wp_frm_item_metas_Crosstab![109]) The field is Activities Use and the above referenced ExtractSerialized...

Anyone have any ideas how to modify this module to account for a field that is null? When the field is null the output from the split function is #error. Thanks. :confused:

Great. Thank you very much.

The link talks about the countif function. Say I have a field that is concatenated and the rows look like this: connected congruent, not connected non congruent, connected congruent, connected, non congruent With this data I want to get tallies of how many times each show up through all the...

This is a follow up question to an older thread: http://www.access-programmers.co.uk/forums/showthread.php?t=100040&highlight Can you use this for a field that is concatenated too? You can in excel. I did this in access and it will return a 1 for those fields with only the exact text option in...

Can you use this for a field that is concatenated too? You can in excel. I did this in access and it will return a 1 for those fields with only the text option in it but if it had the text option I was looking for and then other options in the field with it it returns a 0 for that field when I...

I have been applying this to other fields that have standard responses instead of alphabet concatenation. I am not sure the mdlCountLetters module is working properly with it. Will this apply to other uses outside of alphabet options? I added a sample data set to review. Thanks.

Any help with handling fields with null values? Thanks a bunch.

Attached are sample data sets like I mentioned in my post. Table 1 has one text option in each field and when I create query 1 it gives me the correct count for each option but in query 2 the text is concatenated and what I want to do is get a count for how often text options shows up across...

If I have fields with data that has been concatenated is there a way to run a count function in a query to tell me how many times an option is found in the database? Say 5 rows of data are: Field 1 - a, b, c Field 2 - d, e, f Field 3 - a, b, c Field 4 - d, e, f Field 5 - d, j, k Is there a...

Thanks a bunch. I appreciate it. The sample code worked well for me. I didn't have to do any error checking with the data set I had input so far. :) Mark

I saw that split function link before with microsoft and thought that might be what I needed but struggled trying to figure out how to get it to work properly for me.

I have data written to a table that creates a lot of extra characters called serialized arrays. A few examples are below: a:2:{i:0;s:15:"Individual Work";i:1;s:16:"Small group work";} a:2:{i:0;s:13:"Front of room";i:1;s:31:"Circulating throughout the room";} a:1:{i:0;s:6:"Posted";} Is it...