only show certain topics

  • Thread starter Thread starter Nyd
  • Start date Start date
N

Nyd

I have a database that keeps track of a client's progress
in various meetings. the database has about 7 different
topics to discuss in a meeting (some meetings discuss more
than 1 topic), so i created check boxes for topic 1, topic
2 and so on.

I have created a report based on a query that shows the
clients name, date of meeting, the progress not and the
topic(s). but the report shows each topic and then a
check for the one's that were discused. Is there any way
to do it, so that it will show only the topics that were
discussed on that date instead of showing all the topics?
 
Nyd:

Sure. in your reports underlying query, (assuming you have 7 different
fields) simply add in the conditions row for each field <>0, descending down
the conditions row by column so that it looks something like this:

<>0
<> 0
<>0

etc.

The more practical table design (which also allows for easily adding
questions later,) is to have a structure like this:

Client Date TopicID Discussed

So that the data is put into rows rather than columns. Then in your query
you could use a cross tab by date and client ID and a column for each topic
id.

HTH
 
Back
Top