i need some adivise:
I have to work with a database of bad design.There is a field of name, country and then there are fields :
information_text1 information_text1_date ,
information_text2 information text2_date
information_text5 information text_5 date.
I have generated a query in Access, e.g. selecting all Italien countries. What I want to do now is to manipulate the Recordset, that I get for every italian country, also the date of the last information_textX field, where something is written (information about last change). Therefore i need to look for every recordeset in the 5 information_text fields, (from 5-1) and if I find in one field the information, i have to get the date.
I will use this query in a report, so i need name, country and the required date.
Please if you have an idea, let me know