Search results return Record & Field Name

[IvenBach]

I have a table containing the contents I would like to be returned in the format of "Fieldname | RecordValue". With the help of another poster on my initial post http://www.mrexcel.com/forum/showthread.php?t=588734 I have been able to piece together an import query for what I initially needed. I would like to add some more information ideally as a 2 column table. I have 6 fields (Warranty, Housing, Beam Pattern, Lumens, Watts, and Lifespan) and would like to write a UDF that would include the field name in column 1 and the subsequent info in column 2 but am very unfamiliar with Access on how to do this. Very few records will have all the fields populated, most will be blank (I believe NULL is the correct term) and I had envisioned a slight modification of Norie's original function would be able to do this. I'm lost as to how to call a field name. Is there anyone out there willing to help me along and give me a few pointers in the right direction, or if this is feasible or possible?

If anything is unclear I'll do my best to clarify.

 

[IvenBach]

I looked into that but have more than 255 rows which exceed the limit in access. I will see what I can do about finding a work around for the time being. I have another thread located here http://www.mrexcel.com/forum/showthread.php?p=2923419 that has another of many question's I'm trying to solve.

Edit:Sorry if it seems like I'm begging for answers.