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

Seearch criteria in a question to be presented in a report 5
Showing the max of three fields in a single record 3
Date Average 1
How do I move data in columns (XL) to rows in Access table 3
If/Then/Else Query 6
SQL string for an average over 7 days 2
SUMIF question (I think) 1
Query Question 6

Top