By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,639 Members | 2,000 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,639 IT Pros & Developers. It's quick & easy.

Problem with use of calculated form field in query

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Norbert,

From what you have written, you seem to be able to do the calculated date. So
now what you need is to create a pop-up form from which you can launch your mail
merge letters. On this form you need two textboxes named StartDate and EndDate
and a button to launch the mail merge from the button's Click event. You need to
base the mail merge on a query. The query needs to include the calculated field
and you set the criteria for the calculated field to:
Between Forms!NameOfPopupForm!StartDate And Forms!NameOfPopupForm!EndDate

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Norbert Lieckfeldt" <n@lieckfeldt.net> wrote in message
news:Xn****************************@130.133.1.4...
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.