need a formula

[Guest]

I have finally figured out from reading some of the questions and answers
that I cannot do a calculation in the table. So, now I'm doing it in a query
instead.
This is what I want to do:

Date Rcvd Rip is a column that actually input a date (modified short date)
I need 2 more colums:
Date Due to Monitor (I need it to update automatically 14 days after the
Date Rcvd Rip)
Date Due to MPF (I need this one a month later than the Date Rcvd Rip)

I was actually able to get the expression put on my form (and it actually
works!!)...but then I can't use it in the report.

HELP.

 

[Rick Brandt]

I have finally figured out from reading some of the questions and answers
that I cannot do a calculation in the table. So, now I'm doing it in a query
instead.
This is what I want to do:

Date Rcvd Rip is a column that actually input a date (modified short date)
I need 2 more colums:
Date Due to Monitor (I need it to update automatically 14 days after the
Date Rcvd Rip)
Date Due to MPF (I need this one a month later than the Date Rcvd Rip)

I was actually able to get the expression put on my form (and it actually
works!!)...but then I can't use it in the report.

The same expression you are using in your form should work in the query.


Date Due to Monitor: DateAdd("d", 14, [Date Rcvd Rip])
Date Due to MPF: DateAdd("m", 1, [Date Rcvd Rip])

 

[John Vinson]

I have finally figured out from reading some of the questions and answers
that I cannot do a calculation in the table. So, now I'm doing it in a query
instead.
This is what I want to do:

Date Rcvd Rip is a column that actually input a date (modified short date)
I need 2 more colums:
Date Due to Monitor (I need it to update automatically 14 days after the
Date Rcvd Rip)
Date Due to MPF (I need this one a month later than the Date Rcvd Rip)

I was actually able to get the expression put on my form (and it actually
works!!)...but then I can't use it in the report.

HELP.

As Rick says; with the addition that...

The same expression you are using in your form should work in the query.

.... or on the Report. If you set the Control Source of a textbox on a
form to an expression, you can use exactly the same expression, in
exactly the same way, as the Control Source of a textbox on a Report.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

THANK YOU, THANK YOU.
Although I did have a different formula in the form..I just changed it.!
Thank you for the very quick reply!!