jmofstead
01-22-2010, 08:59 AM
My boss has asked to me create a report out of current data that we have.
A little background:
We are a company that trains multiple facilities. We have 7 safety trainers and the safety manager wants a report that lists all the facilities and the day of the month that facility will recieve training.
I created a cross tab query and got all the information I needed, except when I put this into a report, I cannot get just the day of the month to show up. For example, in the January column, I am wanting to have just 6 show up instead of 1/6/10.
Can anyone help me on this?
Thanks in advance :)
A little background:
We are a company that trains multiple facilities. We have 7 safety trainers and the safety manager wants a report that lists all the facilities and the day of the month that facility will recieve training.
I created a cross tab query and got all the information I needed, except when I put this into a report, I cannot get just the day of the month to show up. For example, in the January column, I am wanting to have just 6 show up instead of 1/6/10.
Can anyone help me on this?
Thanks in advance :)