Reflecting ".0" in word doc when transfer from table column to wor

[Guest]

Dear Sir,
I have a data in Access Table for eg. emp. name & emp. no. etc.
In another table i am tracking p.f. details therefore I used Lookup for
Emp.Name & Emp.No. for easier working.
When I mail merge in word document Emp.Name is seen correctly But Emp.No. is
looking like this eg:10000111.0 which is incorrect.
I want in doc eg:10000111 as entered in table
So here i need help that how could I remove ".0" from that word doc &
Nos.seen as actual.

Also tell me about date when i entered in table it looks correct in table
but while mail merge in doc I see the date with time
for eg.:07-Jun-07
when mail merge in doc I see 07-Jun-07 6.51PM
I dont want this time with date in mail merged document.

Kindly help me out!
Thanks
May God Bless u!
Sajan

 

[Lynn Trapp]

What datatype is your Emp No? It looks like it is probably a number value,
which is causing the decimal precision to show up. I would recommend writing
a query on your table that converts the Emp No to text and formats the date
field to show just the date. and then use that query for your mail merge.