| | |
|
|
|
How to Show Table Dates in Reports as 'X's'? |
|---|
| message from xx on 14 May 2004 |
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 replied to xx on 14 May 2004 |
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?
|
| Ken Snell replied to xx on 14 May 2004 |
DontShowDate: "X"
|
| xx replied to Ken Snell on 14 May 2004 |
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
On Fri, 14 May 2004 11:50:27 -0400, "Ken Snell"
<kthissnellis9@notcomcast.realnet> wrote:
|
| tina replied to xx on 14 May 2004 |
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" <gallagher935@yahoo.com_nospam> wrote in message
news:9vs9a0ha2v7s1v86rtmf3p2mdav743r7vs@4ax.com...
|
| xx replied to tina on 15 May 2004 |
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....
On Fri, 14 May 2004 17:49:38 GMT, "tina" <nospam@address.com> wrote:
|
|
Archived message: How to Show Table Dates in Reports as 'X's'? (Microsoft Access Forms)
