Want a Repeating Field

[Ringers]

I have designed a report with all the right fields and look. Their is a section of the report which displays the a service record/s for that Report. Linked to each service record is a Record Id, but the ID(service_Id) is only appearing for the last record.

I want it to appear for every record, how do i do this?I hope this is clear.

 

[Pat Hartman]

Are you surpressing duplicates?

 

[Ringers]

NO, each service id is unique i have attached a screen shot so you know what i mean.

 

[Pat Hartman]

Have you examined the recordsource? Do all the rows have a value for service_id?

 

[Ringers]

every time you add a record it creates the service_id it's an auto number.

 

[Pat Hartman]

That's nice but it didn't answer my question. Open the query that you are using as the recordsource for the report and look at it.