STORING DATES

[JMG]

Hi,
I dont know why I can't store dates in a table. I have a
start date (I entry this date) and then I calculate in a
form 2 more dates (start date plus 30 days and start date
plus 90 days). I can see the new dates in the form, but
not in the table so I cant make reports or filters,
anything.

Please help! I appreciate any help
Thank's

 

[Rick Brandt]

Hi,
I dont know why I can't store dates in a table. I have a
start date (I entry this date) and then I calculate in a
form 2 more dates (start date plus 30 days and start date
plus 90 days). I can see the new dates in the form, but
not in the table so I cant make reports or filters,
anything.

Calculations don't belong in tables. They belong in forms, reports, and
queries.

Create a query based on your table that uses the same expressions as your
form to calculate the two dates and then use the query instead of your
table. Delete those fields from the table altogether.