Using Now() In Access

[sup3rsgt]

Hi,



I have imported an Excel Workbook in Access

In the spreadsheet was a formula to say how old an object is (=(NOW()-$L122)/365)

I was wondering if there was a way of replicating that in Access, and match to each object in the Database

Regards
Toby

[ranman256]

yes , but to calc the time (in days, d), use DateDiff("d",dateOfObj,Now())
(or hours h, or seconds, s....)
but what do you call an object? You use it on data.

[sup3rsgt]

By Object I mean an Item in the Database so in this case a Server.

How would i apply that? would it be as an expression?

[ranman256]

yes, use it as an expression in a query or or form on a field.

(objects are something different in access and excel.)

[sup3rsgt]

Thanks for the help got that working now.

One more question is there any way or adding colour similar to conditional formatting?

[June7]

Textbox and combobox controls have Conditional Formatting. Can be found on the ribbon Format tab when form or report in design view.