Combining Fields in a Textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
"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
 
Worked like a charm. Thanks!

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

Jeff Boyce said:
"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 said:
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.
Click to expand...
Click to expand...
 
Back
Top