=[count] & Report!count

[sharkchaser]

=[count] & Report!count

I don't understand the "& Report!Count"

It's providing the correct answer but with the number 18 in front of the correct results.

ie.

correct answer result from above statement
17 1817
7 187
4 184

Any ideas . . . Thanks Rick

 

[sharkchaser]

Okay I solved it. (?)

In the txtBar text box I placed =Report!count

And I discovered that the exclamation point means the the user created the field.

Thanks

Rick

 

[dhookom]

The unresolved [Count] will return the number of controls and other objects in your report design. That's why it is important to use naming conventions and avoid reserved words. Allen Browne's Microsoft Access: Applications and Utilities - Problem names and reserved words in Access

Duane
Hook'D on Access
MS Access MVP