Search results

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

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

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