I have an expression on my form but now need the data to show on t

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Many thanks to Al Camp I have now sorted my problem with my DateDiff function
within my form but I would also like this information to show on the table
once a record of a client is finhished with or also while live, for reporting
purposes.

When creating the reports I require I am transferring the table information
into Excel, but unfortunately I also require the duration field which is only
showing as '0' even though the right answers are showing on the form.

I have a basic table listing each field which all show on the form also.
Within my Duration Field on the form I have used the following expression
DateDiff("d",[Date of Allocation],[Est Comp Date]).

Any assistance would be much appreciated. Sorry don't know how much more
info you need from me to answer.

Many thanks
 
kiwi said:
Many thanks to Al Camp I have now sorted my problem with my DateDiff
function within my form but I would also like this information to
show on the table once a record of a client is finhished with or also
while live, for reporting purposes.

When creating the reports I require I am transferring the table
information into Excel, but unfortunately I also require the duration
field which is only showing as '0' even though the right answers are
showing on the form.

I have a basic table listing each field which all show on the form
also. Within my Duration Field on the form I have used the following
expression DateDiff("d",[Date of Allocation],[Est Comp Date]).

Any assistance would be much appreciated. Sorry don't know how much
more info you need from me to answer.

Many thanks
Click to expand...

Calculations are not stored, they are calculated as needed. Put your
calculation in a query and use the query for reporting instead of the table.
 
Back
Top