I have field1, field2, field3, field4, field5, field6, field7
I have a new field called matcstring
would like totake the results of each field if not null and create a string in matchstring field so:
matchstring field would be "2,5"
am in access 2010 query grid or a function to do same in vba would be ok