Form has due date Table does not

[dpepper]

Hi,

I made a database and the "Forms" I have a due date plugged in to add 45 days from the date info entered. In table view I have no due dates listed. I tried to put in a formula but I'm either doing it wrong or putting it in the wrong spot.

This is in the control source in the data tab Design View Forms and it works great.

=DateAdd("d",+45,[ Date Entered])

Can I or where can I add this information in the Table to get the date listed?

Sincerely,
Dolores

 

[PHV]

Dont't store calculated/derived values in a table but retrieve them with a query:
SELECT *, [Date Entered]+45 As [Due Date]
FROM yourTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886