DateAdd

[Burnsie]

Hi everyone.



First time post, so please be gentle with me.

I must admit, I'm not too hot on Access...

I want to create a database where certain fields are populated based on data in other fields.

More specifically, I have one filed (Risk Assessment) that is populated on the day a new record is opened (using the "=Date()" term in the "Default Value" option in the table design view).

What i'm looking for is a form where two other fields "Reassessment date 1" and "Reassessment date 2" are automatically calculated 90 days and 180 days after the Risk Assessment date.

I have attempted to follow a few YouTubes, but always get an error or no date appears in my new field.s

Any suggestions?

[CJ_London]

I have attempted to follow a few YouTubes, but always get an error or no date appears in my new field.s

all we can do is do what the youtube does - provide an example. Suggest you copy and paste your attempt which doesn't work with the error you get so we can advise you where you are going wrong.

[Burnsie]

Hi.

thanks for your reply.

I will C+P what I can.

You can't attache a file to replies, no?

Edit, you can...hang on

[ArviLaanemets]

Formulas are simple part.

AssessmentDate + 90

and

AssessmentDate + 180

But the rest is more complicated.
1. Where you need this calculation be made - in some control (a formula) or in VBA procedure/Form or control event (a VBA expression)
2. From where you need to read AccessmentDate (lookup by some other parameter from table/a control or linked field on same form/a control or source table field from parent form).

To give some help there isn't enough information.

[Burnsie]

hmmm...the upload option doesn't seem to work.... nothing happens.

[CJ_London]

try zipping the file first - but it should not need a file, just a copy and paste of the code.

If you are sending a db file, strip out all unrelated tables/queries forms etc, remove any autoexec you may have, then compact and repair before zipping - and provide a brief description of how to get the problem (form name/control name)