don't want column to show

  • Thread starter Thread starter nydia
  • Start date Start date
N

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?
 
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
 
Back
Top