Formulas? cbremar 6/12/2007 10:42:01 PM I have been requested to create a merge document. One of the fields that is being requested is to calculate a date in the future (5 days from today, 89 days from, etc.). Can you create a field in a merge document that would calculate something like that? If so, how would one do it?

Re: Formulas? "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/13/2007 12:47:54 AM If possible, do this in your data source - e.g. if it's an Access/SQL Server database, make a query/view that calculates date+5 or date+89, use that as the data source and insert that field just like any other. That won't work unless you know the number of days you need to add at the point when the query is executed (which you may not know if, for example, the user types the value into an ASK field). Otherwise, download the macropod's attachment at : http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 You may also find http://tips.pjmsn.me.uk/t0004.htm useful. Peter Jamieson "cbremar" <cb[ at ]discussions.micosoft.com> wrote in message news:A1E7E2A5-895B-4673-A754-8DEDEB67AEA0[ at ]microsoft.com... [Quoted Text] >I have been requested to create a merge document. One of the fields that >is > being requested is to calculate a date in the future (5 days from today, > 89 > days from, etc.). Can you create a field in a merge document that would > calculate something like that? If so, how would one do it?

Re: Formulas? cbremar 6/13/2007 1:41:00 AM I wish I could do that, but the data source, an Excel spreadsheet, will be controlled by someone else. Thanks for the links. I'll take a look at them to see if they contain what I need. In the meantime, do you know how I would set up the merge field to calculate this info? Thanks again. "Peter Jamieson" wrote: [Quoted Text] > If possible, do this in your data source - e.g. if it's an Access/SQL Server > database, make a query/view that calculates date+5 or date+89, use that as > the data source and insert that field just like any other. That won't work > unless you know the number of days you need to add at the point when the > query is executed (which you may not know if, for example, the user types > the value into an ASK field). > > Otherwise, download the macropod's attachment at : > http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 > > You may also find http://tips.pjmsn.me.uk/t0004.htm useful. > > Peter Jamieson > > > "cbremar" <cb[ at ]discussions.micosoft.com> wrote in message > news:A1E7E2A5-895B-4673-A754-8DEDEB67AEA0[ at ]microsoft.com... > >I have been requested to create a merge document. One of the fields that > >is > > being requested is to calculate a date in the future (5 days from today, > > 89 > > days from, etc.). Can you create a field in a merge document that would > > calculate something like that? If so, how would one do it? > >

Re: Formulas? "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/13/2007 6:59:21 AM [Quoted Text] > In the meantime, do you know how I would > set up the merge field to calculate this info? The trouble is that the calculation using fields is not at all simple, which is why you need the stuff in here: (it shows you how to do the calculations using fields): http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 << >I wish I could do that, but the data source, an Excel spreadsheet, will be > controlled by someone else. >> You may still be able to do the calculation "in the data source" using Word VBA to issue the necessary Jet SQL. It's described in the other article. Peter Jamieson "cbremar" <cb[ at ]discussions.micosoft.com> wrote in message news:A401622C-7049-4091-8C6B-0E67D30B6880[ at ]microsoft.com... >I wish I could do that, but the data source, an Excel spreadsheet, will be > controlled by someone else. Thanks for the links. I'll take a look at > them > to see if they contain what I need. In the meantime, do you know how I > would > set up the merge field to calculate this info? > > Thanks again. > > "Peter Jamieson" wrote: > >> If possible, do this in your data source - e.g. if it's an Access/SQL >> Server >> database, make a query/view that calculates date+5 or date+89, use that >> as >> the data source and insert that field just like any other. That won't >> work >> unless you know the number of days you need to add at the point when the >> query is executed (which you may not know if, for example, the user types >> the value into an ASK field). >> >> Otherwise, download the macropod's attachment at : >> http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 >> >> You may also find http://tips.pjmsn.me.uk/t0004.htm useful. >> >> Peter Jamieson >> >> >> "cbremar" <cb[ at ]discussions.micosoft.com> wrote in message >> news:A1E7E2A5-895B-4673-A754-8DEDEB67AEA0[ at ]microsoft.com... >> >I have been requested to create a merge document. One of the fields >> >that >> >is >> > being requested is to calculate a date in the future (5 days from >> > today, >> > 89 >> > days from, etc.). Can you create a field in a merge document that >> > would >> > calculate something like that? If so, how would one do it? >> >>