The Problem is that in one table there a 3 fields and if in these 3 fields something is written in than he should show the ID with the first field, then the ID with the second field and afterwards the ID with the third field and then he should go to the next id.
And that's the problem.
I tried it with a recordset and with if ... else stuff, but he only shows the first id and don't duplicate it in that cases.
Are you saying that each record, from your RecordSource object, contains six pertinent fields? Three of those fields are values and three of those fields are companion IDs? And even thought all these are on a single record, you want it to appear as though they are three separate records?
In other words, your printout will look like this:
One field is e.g. Nr of books total, title,...
And 6 other fileds containing:
Nr lended books1
Date received back1
Nr lended books2
Date received back2
Date received back3
These fields are all columns !!!
So thats kind of library.
In total we got e.g.3 equal book
Now we want to create a report containg 4 rows.
First: Nr of books
Second: Nr lended books1
Third: Nr lended books2
Fourth: Nr lended books3
Thats kind of stupid example i know, but my english does not allow me to gice any better
The amin problem is that we select data into a recordset and want to display all lines and some columns in differnt rows !
By now it only displays the first row of data stored in the Recordset, not allowing to display part of this row in the next row and neither allowing to display the other rows of the RS