
Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
I have a database that has a column with date info in it. I merge this info
into a report and would like the capability of having the report generated by
a start date and end date. My goal is to try and recreate the report for a
date without having to go through the database and unselect info after a
certain date.
> Where are you getting the date information from and what do you want to do
> at a certain date?
>
> > I have a database that I use to mail merge the info into another
> > document. I would like to be able to merge the info based on a date.
> > Is that possible.
oli merge - 20 Mar 2007 16:53 GMT
Hi Sandy,
Not certain exactly what you mean but to select records based on the date
column you have several options.
I would just filter the excel spreadsheet using auto or advanced filter
depending on how complex a selection criteria you have and merge from that.
You could also use an IF statement in word to select based on a criteria,
probably nested with the "next record" statement, but its seems a bit
unneccesarily complicated to me.
> I have a database that has a column with date info in it. I merge this info
> into a report and would like the capability of having the report generated by
[quoted text clipped - 8 lines]
> > > document. I would like to be able to merge the info based on a date.
> > > Is that possible.