ACCESS FEED: [MS_AccessPros] Re: How to have cell auto-date two weeks forward from another cell's date

Selasa, 13 September 2011

[MS_AccessPros] Re: How to have cell auto-date two weeks forward from another cell's date

In databases "cells" are called fields or columns. To calculate a column, you can use a query. Calculated values are not stored in tables.

For example:

Select CustomerID, DateBilled, DateAdd("d", 14, DateBilled) As ReminderDate
From tblInvoice
Where DatePaid Is Null;

> From: florenceps1217 <florenceps1217@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, September 13, 2011 7:29 AM
> Subject: [MS_AccessPros] How to have cell auto-date two weeks forward from another cell's date
>
> Â
>
> Using Access 2003
>
> How can I have a cell auto-date based on 2 weeks from a "Date Issued"
> date, or is that even possible?
>
> Thank you.
>
> Florence
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>