Search results

Yes, Access 2010. I wanted to provide some data verification at the table level, but I suppose it could be incorporated into a form. Possibly nothing can be done, but I thought I’d ask. Thanks for trying. Maybe it will have to wait until I get some VB skills.

The data type 'Calculated' is included in the drop down. I would like to know how to use a system date to populate a field.

Sorry I wasn’t clear. I created a table. One of the fields in the table I named Active. I set the Data Type for Active to ‘Calculated’. In the Field Properties for Active is Expression. Opening the Expression Builder (ie. I clicked on the “…” button associated with Expression) I was able...

I didn't. I wanted to use it but Access issued an error message. I would like to find out if there is a way of incoporating a date in a calculated field.

In Access 2010, I have set a field type to ‘calculate’ but there appears to be a restriction related to date. I wanted to use something link the following: IIf(([EndDt]>date()),1,0) However, the error message displayed is pretty clear cut. Is there a way around this? I just wanted to populate a...