We help IT Professionals succeed at work.

Line number for each record in a report

howruaz9
howruaz9 asked
on
Hi experts,

I have a Ms Access report based on a query with the following parameter:
FROM [qryClientList]
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?

Thank you!

LL
Comment
Watch Question

MIS Liason
Most Valuable Expert 2012
Commented:
I don't know how you created/added your line numbers, ...but try this, it woks fine for me filtered.

So in my case I am opening the report with a filter, and leaving the source table/query alone (no parameter)



Access-EEQ-ReportLine-Numbers.mdb
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
here is the code for two filters (text for name, and a numeric range for Amount)

DoCmd.OpenReport "YourReport", acViewPreview, , "cName=" & "'" & Me.cName & "'" & " AND " & "Amount>=" & 50
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
Some notes:

In my sample you can ignore the Running sum field (I based this sample on a previous sample)


By opening the report with a filter, you can leave the Reports recordsorce without any parameter criteria.
This way you can still open the report on its own (by itself without the form) without triggering the annoying parameter prompt...
;-)

Jeff

Author

Commented:
Hi Jeff,

I'm trying your suggestion to open the report with a filter, just to let you know while I'm working on it.

Thanks,

LL

Author

Commented:
Thank you very much, Jeff. It's working now.

I don't know what exactly I did wrong before, but I'm so glad it got fixed.

Thanks again and wish you a wonderful holiday season!!!

LL
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Great, thanks


;-)

Jeff