Combining Fields in a Textbox

[This Guy]

I have two fields in my query that read like this:

Book Page
1 10
2 11
3 12
4 13
5 14

On my report I want to combine them in one textbox in the detail section and
I am trying to do so like this:

=[Book] &"/"& [Page]

And it comes out like this:

1/10
2/10
3/10
4/10
5/10

Why is the Page repeating itself and not following the query?

Thanks.

 

[Jeff Boyce]

"Page" is a reserved word in Access. If you name a field "Page", then tell
Access to show you [Page], you get whatever ACCESS decides "Page" means (and
in your situation, it doesn't mean what you think it does).

Change the name of your field in your query to something else, say,
"PageNbr", and call that out in your report
= [Book] & "/" & [PageNbr]

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[This Guy]

Worked like a charm. Thanks!

I would also like to say that this forum is a lifesaver and I love all of
you. Seriously.

"Page" is a reserved word in Access. If you name a field "Page", then tell
Access to show you [Page], you get whatever ACCESS decides "Page" means (and
in your situation, it doesn't mean what you think it does).

Change the name of your field in your query to something else, say,
"PageNbr", and call that out in your report
= [Book] & "/" & [PageNbr]

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have two fields in my query that read like this:

Book Page
1 10
2 11
3 12
4 13
5 14

On my report I want to combine them in one textbox in the detail section
and
I am trying to do so like this:

=[Book] &"/"& [Page]

And it comes out like this:

1/10
2/10
3/10
4/10
5/10

Why is the Page repeating itself and not following the query?

Thanks.