don't want column to show

[nydia]

I have a database that keeps track of clients and when
they attend meeting. There are 2 types of meetings (group
or individual). i created a query that shows the date of
the meeting, the type of meeting and the duration of the
meeting and the billingcode(various #). I then created a
report based off this query. The report is grouped by
clientID and then meeting type (group or individual). My
problem is that when a client attends individual sessions,
there are no billing codes required,

so, how can i do it on the report so that in the group
session the billing code column is there, but in the
individual section, the billing code is not there?

 

[Fons Ponsioen]

Without knowing how your table is setup, you could sit the
textbox for that column with a simple IIF() statement, for
instance I' assume the variable is named "billingcode" and
the session variable is "session" and is either I or G
in the applicable text box for the billingcode I would put
the statement
IIF([Session] ="I","",[billingcode])
Hope this helps.
Fons