Discuss "Page Number Manipulation" in the Microsoft Access forum.

2 Reports

First Report "Inspection"

Page Numbers Start at 8, 9, 10 etc
Report is grouped by Operation Number,.. I.e. "201-1 = Page 8,.. 202-1 = Page 9. Note the main group numbers "201" and "202" So to make things easier to understand,.. the -1 is standard and not related to the 2nd report.

2nd Report i have Findings,..

Report is grouped by Finding Number,..

I.e. "301-1 should= Page 8a,.. 301-2 should= Page 8b ,.. 301-3 should= Page 8c Note the relationship between the Inspection and Finding Number is +100. in this case they are related to 201-1 "Page 8" of the Inspection Report

302-1 and 302-2, 302-3 are related to the 202 group,.. again as in all cases the relationship between the Inspection and Finding Number is +100 as before these will be page 9a and page 9b, page 9c,..etc

So in summary what i need.

1st - The findings groups need to relate to the inSpection page numbers on the first report,.
2nd - Finding 301-1 and 301-2, 301-3 should go 8a 8b 8c,.. and when it gets to 302-1 "on the same report" it Goes Page 9a 9b 9c,...

Hope this makes sense,.. i don't expect an answer on this one,.. but if you could share some logic,.. maybe i can "hack" it some how

__________________
If i helped you, make me famous by clicking the

Long story short inspection 201-1 "disregard the -1" can have multiple findings,..

And the page number on the findings report must be the same as the inspection its related to,.. the multiple findings must be paged with a, b c etc...

Maybe i'll have to somehow work the page numbers out in query.

For the value of the Inspection I would do something like:
And then for Findings, I would do:

Only needed the second part,..

, ... well that appears to have worked,.. need to test it on a few more numbers "but" real good

thanks sbenj

you're welcome

Let's break it down:

To break it down, if [yourfindingstring]= "202-1"

The first part would be: "Page " & Val(Mid("202-1",2,2))+7 & chr(val(Mid("202-1", instr("202-1", "-")+1))+64)

The second part: "Page " & Val("02")+7 & chr(val(mid("202-1", 4+1))+64)

The third part: "Page " & 9 & chr(val(mid("202-1",5))+64)

The fourth part: "Page " & 9 & chr(val("1")+64)

The fifth part: "Page " & 9 & chr(65)

The sixth part: "Page " & 9 & "A"

The final outpout: "Page 9A"

Nice break down,.. thanks for sharing