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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top