I would highly recommend you restructure your table to
Comment
CommentOther
CommentText
QuestionType
Your query would simply display all records where whatever your response field isn't null. I have dealt with path you are attempting to go down, and it isn't pretty. the table I had to deal with had comment1 .... comment8. This table format will only lead to pain and suffering.
Each question and response should be it's own record. This format would enable you to track unanswered questions and only select those questions which were answered.
Best of luck.
TJ
Margaret <[EMAIL PROTECTED]> wrote:
Comment
CommentOther
CommentText
QuestionType
Your query would simply display all records where whatever your response field isn't null. I have dealt with path you are attempting to go down, and it isn't pretty. the table I had to deal with had comment1 .... comment8. This table format will only lead to pain and suffering.
Each question and response should be it's own record. This format would enable you to track unanswered questions and only select those questions which were answered.
Best of luck.
TJ
Margaret <[EMAIL PROTECTED]> wrote:
Well, I would, but I'm not sure that would work. Let me tell you
about the structure of the table. There are the following fields:
Comment1
Comment1Other
Comment1Text
Comment2
Comment2Other
Comment2Text
Comment3
Comment3Other
Comment3Text
There may or may not be data in any of these fields depending on
what the respondent felt toward the options given. I have the
feeling I'm not going to be able to accomodate this on the report,
what I WANT is if Field 1, 4, 6, 8 and 9 have data, then only the
data and the labels for the data print.
--- In [email protected], [EMAIL PROTECTED] wrote:
>
> Base your report on a query that only has he fields you want.
>
> Hal McGee
> Engineering Data Manager
> Group Engineering - Process and Compliance
> Seating Products Group
> B/E Aerospace
> Winston-Salem, NC
>
>
>
> "Margaret"
>
<[EMAIL PROTECTED]
>
ahoo.com> To
> Sent by:
[email protected]
>
AccessDevelopers@ cc
>
yahoogroups.com
>
Subject
> [AccessDevelopers] Don't
want blank
> 11/15/2005 05:05 fields printing on
report
>
PM
>
>
> Please respond
to
>
AccessDevelopers@
>
yahoogroups.com
>
>
>
>
>
>
> I'm sure there is a very easy way to do this...but not being a real
> strong user of Access, need help!! I am going to print a report
but
> many fields in the table are blank. I don't want those fields
> referenced on the report at all, just the fields with data. How
can I
> do this?
>
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
>
>
>
>
SPONSORED LINKS
>
> Microsoft access Microsoft access help Microsoft access
> developer training
>
> Microsoft access Microsoft access Microsoft access
> training course programming tutorial
>
>
>
> YAHOO! GROUPS LINKS
>
> Visit your group "AccessDevelopers" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
Yahoo! FareChase - Search multiple travel sites in one click.
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access training |
| Microsoft access training course | Microsoft access programming | Microsoft access tutorial |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
