I have a Ms Access report based on a query with the following parameter:
WHERE ((([qryClientList].Facilitator)=[Forms]![frmFacilitatorName]![cboCRF]) AND (([qryClientList].Filestatus)="active"))
The report is running okay, only when I added the line number for each record, no matter it's overall or over group, the consecutive number doesn't go to the next page. It starts all over again from 1 for each page.
When I deleted the parameter, the line numbers are okay for the entire report.
How do I keep the paremeter and let the number work?