Selasa, 13 September 2011

Re: [MS_AccessPros] Re: How to ...auto-date... -- OT: Welcome Pat Hartman

 

Welcome, Pat! Nice to see you posting here :)

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Tue, 9/13/11, patriciahartman wrote:
>
>
> 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
> > 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

__._,_.___
Recent Activity:
MARKETPLACE
A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar