Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am attempting to create a merge template between access 2002 & Word 2002. I
have several date fields where sometimes there is a date and some times there is no date. Word is currently inserting todays date in this field if it is blank. Is it possible to get this field to be blanked out when there is no data in the field in Access? Cheers Alan |
#2
![]() |
|||
|
|||
![]()
I have also just noticed that for any dates where the day is less than 12 my
switch is not working correctly. {MERGEFIELD CRdate \@ "d-MMM-yy" MERGEFORMAT} ie 2nd of september 2003 (entered in Access as 02/09/2003) comes into word as 9-Feb-03. For all other dates it is working fine. Can some one help me with this too? I am confused! Cheers Alan "Alan" wrote: I am attempting to create a merge template between access 2002 & Word 2002. I have several date fields where sometimes there is a date and some times there is no date. Word is currently inserting todays date in this field if it is blank. Is it possible to get this field to be blanked out when there is no data in the field in Access? Cheers Alan |
#3
![]() |
|||
|
|||
![]()
I would use the format function in an Access Query in association with the
IFF function and then use the Access Query as the data source. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Alan" wrote in message news ![]() I have also just noticed that for any dates where the day is less than 12 my switch is not working correctly. {MERGEFIELD CRdate \@ "d-MMM-yy" MERGEFORMAT} ie 2nd of september 2003 (entered in Access as 02/09/2003) comes into word as 9-Feb-03. For all other dates it is working fine. Can some one help me with this too? I am confused! Cheers Alan "Alan" wrote: I am attempting to create a merge template between access 2002 & Word 2002. I have several date fields where sometimes there is a date and some times there is no date. Word is currently inserting todays date in this field if it is blank. Is it possible to get this field to be blanked out when there is no data in the field in Access? Cheers Alan |
#4
![]() |
|||
|
|||
![]()
I am currently using an Access Query as the data source.
What are the format function and IFF function and what do i need to do with them? "Doug Robbins" wrote: I would use the format function in an Access Query in association with the IFF function and then use the Access Query as the data source. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Alan" wrote in message news ![]() I have also just noticed that for any dates where the day is less than 12 my switch is not working correctly. {MERGEFIELD CRdate \@ "d-MMM-yy" MERGEFORMAT} ie 2nd of september 2003 (entered in Access as 02/09/2003) comes into word as 9-Feb-03. For all other dates it is working fine. Can some one help me with this too? I am confused! Cheers Alan "Alan" wrote: I am attempting to create a merge template between access 2002 & Word 2002. I have several date fields where sometimes there is a date and some times there is no date. Word is currently inserting todays date in this field if it is blank. Is it possible to get this field to be blanked out when there is no data in the field in Access? Cheers Alan |
#5
![]() |
|||
|
|||
![]()
Sorry, typo there, it should have been IIF
IIF([CRDate]="","",Format([CRDate, "dd-MMM-yy)) -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Alan" wrote in message ... I am currently using an Access Query as the data source. What are the format function and IFF function and what do i need to do with them? "Doug Robbins" wrote: I would use the format function in an Access Query in association with the IFF function and then use the Access Query as the data source. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Alan" wrote in message news ![]() I have also just noticed that for any dates where the day is less than 12 my switch is not working correctly. {MERGEFIELD CRdate \@ "d-MMM-yy" MERGEFORMAT} ie 2nd of september 2003 (entered in Access as 02/09/2003) comes into word as 9-Feb-03. For all other dates it is working fine. Can some one help me with this too? I am confused! Cheers Alan "Alan" wrote: I am attempting to create a merge template between access 2002 & Word 2002. I have several date fields where sometimes there is a date and some times there is no date. Word is currently inserting todays date in this field if it is blank. Is it possible to get this field to be blanked out when there is no data in the field in Access? Cheers Alan |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date fields | Microsoft Word Help | |||
Empty Mail Merge Fields | Microsoft Word Help | |||
Empty Mail Merge Fields | Microsoft Word Help | |||
date format problem in access 2002 | Tables | |||
Why does the date format change when I mail merge from Access? | Mailmerge |