Due Date?

[Sen]

Uhm.. How can I make a field that has a due date 7 days after you order it.. Automatically will set the due date?

[JoeM]

You would just use a Calculated field in a query (since it is a function of another field, there is no reason to physically store it), i.e.

DueDate:[OrderDate]+7

[RayMilhon]

In Access 2010 you are also allowed to have calculated fields in tables. I've never found a valid reason to do it but it is available.

[cysklement]

Hi, I need help with creating an access query which works as showing data that is going to due prior to 14 days.
I need help with the query code.

I want it to work this way:

if duedate = or within 14 days due and receive notification = yes : show data.

[JoeM]

In your query, place the following Criteria on the same Criteria row:

Under your Due Date field: Between Date() and (Date() +14)
Under your Receive Notification field: "Yes"

That's all there is to it!