Controlling Display of data on a Report

[Guest]

I am new to Access. But I have used Crystal Reports. I would like to be able
to specifically control where data is displayed on a report.
Perhaps I could use a text box and write an expression like "If
(Item#=AR0001 then
display the "Amount" here)

Then I can mimic an excel form that is presently being used.

Any suggestions would be appreciated

 

[Marshall Barton]

I am new to Access. But I have used Crystal Reports. I would like to be able
to specifically control where data is displayed on a report.
Perhaps I could use a text box and write an expression like "If
(Item#=AR0001 then
display the "Amount" here)

Then I can mimic an excel form that is presently being used.

The control source expression in a text box could be:

=IIf([Item#] = "AR0001", Amount, Null)

but I'm not at all sure that's the right way to accomplish
whatever you're trying to do.

 

[Guest]

I am new to Access. But I have used Crystal Reports. I would like to be able
to specifically control where data is displayed on a report.
Perhaps I could use a text box and write an expression like "If
(Item#=AR0001 then
display the "Amount" here)

Then I can mimic an excel form that is presently being used.

The control source expression in a text box could be:

=IIf([Item#] = "AR0001", Amount, Null)

but I'm not at all sure that's the right way to accomplish
whatever you're trying to do.

I'll try it out and see what happens. Even if it does work, there may be
better ways to do the same thing.

Thank you

 

[Guest]

I tried out the code and it did what I wanted. Still not sure it is the right
thing, but either way I learned something.

Thanks again

I am new to Access. But I have used Crystal Reports. I would like to be able
to specifically control where data is displayed on a report.
Perhaps I could use a text box and write an expression like "If
(Item#=AR0001 then
display the "Amount" here)

Then I can mimic an excel form that is presently being used.

The control source expression in a text box could be:

=IIf([Item#] = "AR0001", Amount, Null)

but I'm not at all sure that's the right way to accomplish
whatever you're trying to do.

I'll try it out and see what happens. Even if it does work, there may be
better ways to do the same thing.

Thank you