×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Is it possible to have underlying logic in a report ?

Is it possible to have underlying logic in a report ?

Is it possible to have underlying logic in a report ?

(OP)
I don't think anyone will be interested in answering my prior post because of the way i stated my issue~  perhaps restating it will make it simpler and one of the technically astute visitors will deem it worthy of answering ~ !
 
Is there a way to get an access report to display different fields on each report line (column)based on the contents of a field in a record ?  

I have a table with "yes/no" bytes set that correspond to specific fields in the same record ~   I would like to create a report on the contents of the table so as to print a specific field from the record based on the "yes" or true state of the yes/no bytes.

I am having trouble figuring out a technique.

basically, what i want to do is if, in the record. fieldA is "true" print field 21 else if fieldB is true pring field 35 else if fieldC is true print field 10.

anyone with a suggestion ?  (seems I need logic underlying the report as it processes each record but for the life of me cannot figure out how to do this (or if it is even possible))

thanks !

RE: Is it possible to have underlying logic in a report ?

It was answered.  Yesterday.  What additional information do you need?  What NEW question are you asking?  What NEW information are you providing?

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

RE: Is it possible to have underlying logic in a report ?

it is/was posted and responded to under the MS Access General Forum.  There are four responses to your inquiry.  You did not mark the post for notification, so you were not notified (via e-mail) of those responses.

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

RE: Is it possible to have underlying logic in a report ?

(OP)
YES, THANKS MICHAEL, I JUST LOOKED THERE AND FOUND IT ~  VERY WONDERFUL INFORMATION ~  thankyou so much !
Paul

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close