How to Show Table Dates in Reports as 'X's'?

  • Thread starter Thread starter xx
  • Start date Start date
X

xx

Help:

How do I get a query or report to change dates to 'X's' without
messing up my original data?

I have a data table with several dates that identify when various
training programs were completed. I also have some queries that pull
the training data of certain individuals, based on their work
locations. I then have reports linked to the queries.

What I would like to do is to not have the dates show up in the
reports, but rather have just a simple 'X' appear in the place of each
date. So how do I get the query or report to change each date to an
'X' without messing up my original data?

Thanks in advance,

-Ted
 
Thank you for the response, but I fear I need to ask for some
additional help. I replaced the field name in the query (we'll call
it 'Workshop 1") with DontShowDate: "X". What it did was enter an
"X" in every single cell in that column. It did not matter if there
was a date entered for a particular person or not. If the person has
not had that workshop, I want to leave their corresponding cell blank.

So what am I doing wrong? I apologize for being ignorant :)

Thanks again,

-Ted
 
if i understand correctly that you're calling your date field [Workshop 1],
then try changing the calculated field in the query to

DontShowDate: IIf([Workshop 1] Is Null,Null,"X")

hth
 
It helped perfectly.

Sincere thanks to you and the others for your responses. The
willingness of so many to take the time to share their knowledge is
what, in my mind, makes the internet so terrific.

Thanks again....


if i understand correctly that you're calling your date field [Workshop 1],
then try changing the calculated field in the query to

DontShowDate: IIf([Workshop 1] Is Null,Null,"X")

hth


xx said:
Thank you for the response, but I fear I need to ask for some
additional help. I replaced the field name in the query (we'll call
it 'Workshop 1") with DontShowDate: "X". What it did was enter an
"X" in every single cell in that column. It did not matter if there
was a date entered for a particular person or not. If the person has
not had that workshop, I want to leave their corresponding cell blank.

So what am I doing wrong? I apologize for being ignorant :)

Thanks again,

-Ted
Click to expand...
Click to expand...
 
Back
Top