MS Access 2002 here. I am just trying to set up a simple database for a
friend who's an optician. Basically, all clients with address details, date
of last eyetest and a drop-down combo box to choose a number of months to
the next eyetest (3,6,12,24). I then have a calculated field in the form
which works out the date of the next appointment on the basis of the
previous two sets of information .
All that works [not least due to googling in this group!]. I am now trying
to set up a query to allow for a mail-merged letter to be sent out to those
clients where the calculated data field would have shown a date in the
previous week.
I don't know how to do this. I can't use the table as the table does not
show the calculated value. I guess I need to create a new query which will
show the calculated field but don't know how to go about this. Any pointers
on where to look in the helpfile would be very much appreciated!
Norbert