Calculated field

[jim]

I am trying to calculated the number of days between to manually entered
dates.Example.... Start date=02/05/08 and due date=02/08/08.... 3 days right?
how do i get it to show on my form and entered into my table?

 

[Maurice]

Jim,

It is bad practice to store calculated fields in your tables. If you need to
store is somewhere you typically use a query for this. You'd then use yhis
query as the source for your form.

Calculation in the query: create a new field called difference like this

difference: datediff("d",[firstdatefield],[seconddatefield])

hth

 

[jim]

Maurice,

Thanks for the help. I am however still fighting the form/query. When I type
in the line you gave me it asks me for an input. Please help.

Jim,

It is bad practice to store calculated fields in your tables. If you need to
store is somewhere you typically use a query for this. You'd then use yhis
query as the source for your form.

Calculation in the query: create a new field called difference like this

difference: datediff("d",[firstdatefield],[seconddatefield])

hth
--
Maurice Ausum

I am trying to calculated the number of days between to manually entered
dates.Example.... Start date=02/05/08 and due date=02/08/08.... 3 days right?
how do i get it to show on my form and entered into my table?

 

[Maurice]

Jim,

You did replace the fields with the names of your own datefields right? The
two fieldnames I provided as references replace them with your own
fieldnames...
--
Maurice Ausum

Maurice,

Thanks for the help. I am however still fighting the form/query. When I type
in the line you gave me it asks me for an input. Please help.

Jim,

It is bad practice to store calculated fields in your tables. If you need to
store is somewhere you typically use a query for this. You'd then use yhis
query as the source for your form.

Calculation in the query: create a new field called difference like this

difference: datediff("d",[firstdatefield],[seconddatefield])

hth
--
Maurice Ausum

I am trying to calculated the number of days between to manually entered
dates.Example.... Start date=02/05/08 and due date=02/08/08.... 3 days right?
how do i get it to show on my form and entered into my table?