hi,
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
thx andy

You could directly, in design view of the query, specify in each information_text1 field, <>IsNull. only the records where data is present will show on the query & with the date field adjacent. Attach this to recordsource of Desired Report.
Or open a recordset, specify the criteria, have the result populate another table, or form etc...

Dim stSQL as string
Dim rec as ADODB.RecordSet
set rec = New ADODB.RecordSet

stSQL = "SELECT .* " & _
        "FROM tblName " & _
        "WHERE tblName.Information_text1 <> IsNull Or tblName.Information_text2 <> IsNull Or tblName.Information_text3 <> IsNull Or etc.. (I Forget if it's "Not IsNull" or "<> Null")

rec.open stSQL CurrentProject.Connection,adOpenDynamic,adLockOpti mistic

within this recordset, you can manipulate accordingly...
..maybe a start?
good luck!