Data using DateAdd function not showing table.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Atom Agent - 14 Mar 2006 17:47 GMT

The dates that fill in my form using the DateAdd function don't show up in my
table. I'm using the expression =[Placement Date]+45. How do I make it
work? I'm using Access 2000. Thanks!

Reply to this Message

Wayne Morgan - 14 Mar 2006 18:01 GMT

They shouldn't show up in your table. Since you have [Placement Date] in
your table, you can calculate the other date whenever you need it (just as
you're doing). This calculation can be done in a query, form, or report.

Signature

Wayne Morgan
MS Access MVP

> The dates that fill in my form using the DateAdd function don't show up in
> my
> table. I'm using the expression =[Placement Date]+45. How do I make it
> work? I'm using Access 2000. Thanks!

Reply to this Message

Atom Agent - 14 Mar 2006 18:10 GMT

Thank you, Wayne!

> They shouldn't show up in your table. Since you have [Placement Date] in
> your table, you can calculate the other date whenever you need it (just as
[quoted text clipped - 4 lines]
> > table. I'm using the expression =[Placement Date]+45. How do I make it
> > work? I'm using Access 2000. Thanks!

Reply to this Message