Calculated Field

[rolyjavier]

Hello community,

I want to know if its posibble to make a calulated field in a table with this conditions:

• There is a "Yes/No" field , an "Date of Visit" and a "Next Date of visit" fields

So, what I want to make is: If, the "Yes/No" field is checked(like in the picture), I want to add +30 days to "Date of Visit" and display it on "Next Date of Visit" field

I came up with this expression, but is not working:

IIf([Subscription]=Yes,[DateOfVisit]+30,"On Call")

[Micron]

Table calculations are
1) quite limited, and I'm pretty sure IIF functions are not possible
2) ill advised

Do your calculations in queries and forms and don't save them, except in rare cases. "next date" is not one of those cases.

Other notes - I don't see a "Next Date of visit" field.
Don't know what type of file your "comments" attachments is, but db size can get pretty big if you keep attachments in Access tables. Often, developers will store the path to the file as simple text in the table field and use it to access the file.

[June7]

IIf() is available to calculated type field in table.

What does 'not working' mean - error message, wrong result, nothing happens?

I just tried this and get error message trying to save the table.

I think the expression is rejected because mixing data types in the result.

Do calc in query.