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

[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

 

[Kevin3NF]

If you are going to X out every date, why not just remove the control from
the report that is linked to the date field in the query?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Ken Snell]

In the query, use a calculated field in place of the date field:

DontShowDate: "X"

 

[xx]

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

 

[tina]

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]

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

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