-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
First off, you can use the DateAdd() function to add 6 months to the
date value IFSPOriginal:
DateAdd("m", 6, IFSPOriginal)
If the date IFSPOriginal is saved to the table you can use the same
function in the report. Use an unbound TextBox and set its
ControlSource to this:
=DateAdd("m", 6, [IFSPOriginal])
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQD5KIoechKqOuFEgEQJboQCgyHxsDYcCz9HnP2q6vzEm30 pnwF4An27A
fhqZr+nTo3uqW7Y56SvTL5XF
=LrYG
-----END PGP SIGNATURE-----
Mark Lees wrote:
I've created some fields that calculate future dates. The way they are
set up they do not save to a table. This is the expression I used
(=DateSerial(Year([IFSPOrginal]),Month([IFSPOrginal])+6,Day([IFSPOrginal]).
I placed it in the Control Source property. I want to save them to a
table so I can use them on a report.
So the 2 questions are:
1. How do you use a calculated field that doesn't save to a table in
a report?
2. If you have to save it to a table to use it in a report, where do
I put the expression so it does the calculation other than control
source property?