Keep calculated field in table!

R

Robin

Hi there.

I have received some help in how to calculate a field in a form. I now need
to keep it in the table once calculated! How can this be done? I'm also
unsure of the way to calculate the field. The calculation is simple, but it
relies upon 4 other fields.

Date1
Date 2
Date 3
Date 4

CalcDate=Date1+90days unless Date2 is populated. If Date2 has a value, then
CalcDate-Date2+90days. If Date3 has a value, then CalcDate=Date3+90days.

So how do I get Access to work out CalcDate given the situations mentioned?

Many thanks,
Robin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query the same table three times 0
Seearch criteria in a question to be presented in a report 5
A simple query problem 5
Duration calculations 1
Report with conditionnal formatting issue 0
If/Then/Else Query 6
Date Average 1
Calculating Date Fields 3

Top