Controlling Display of data on a Report

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

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
 
JDevine said:
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.
Click to expand...


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.
 
Marshall Barton said:
JDevine said:
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.
Click to expand...


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.
Click to expand...
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
 
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


JDevine said:
Marshall Barton said:
JDevine said:
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.
Click to expand...


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.
Click to expand...
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
Click to expand...
 
Back
Top