Problem with use of calculated form field in query

  • Thread starter Thread starter Norbert Lieckfeldt
  • Start date Start date
N

Norbert Lieckfeldt

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
 
Norbert

If you "have a calculated field in the form that works out the date", you
could use that same calculation in a query to calculate that next eyetest
date.

.... or have I misunderstood?
 
Norbert

If you "have a calculated field in the form that works out the date", you
could use that same calculation in a query to calculate that next eyetest
date.

... or have I misunderstood?
Click to expand...

Well if I could, that would be great - just don't know how to do it! How do
I calculate something in a query? Where do I put the formula?

At the moment I am trying to reference the form field in the query with

Expr1: [Forms]![Main Form]![Next Exam]

but if I put it in the Field section of the query nothing happens (it only
adds an empty field called Expr1) and if I try to put it in the table field
it naturally complains that the text entered isn't an item in the drop down
list. I am flummoxed!

Norbert
 
Norbert

If you "have a calculated field in the form that works out the date",
you could use that same calculation in a query to calculate that next
eyetest date.

... or have I misunderstood?
Click to expand...

Well if I could, that would be great - just don't know how to do it!
How do I calculate something in a query? Where do I put the formula?

At the moment I am trying to reference the form field in the query
with

Expr1: [Forms]![Main Form]![Next Exam]

but if I put it in the Field section of the query nothing happens (it
only adds an empty field called Expr1) and if I try to put it in the
table field it naturally complains that the text entered isn't an item
in the drop down list. I am flummoxed!

Norbert
Click to expand...

Ignore me - I got the calculation going! All I need now is to be able to
create a drop-down box which helps to find records...

Norbert
 
Back
Top