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.
If anything is unclear I'll do my best to clarify.
Last edited: