#Name?

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

I am using the following on a report

=Format(Sum([TimeTaken])*24*60,"#.00")

where Time taken is in hh:mm and tis works OK on my PC. When transferred to
another PC I get #Name? in the field

Thank
 
There are some bugs with using the Format function in Queries, maybe this is
happening here. The workaround in Queries is to write you own function
(MyFormat or something) that does the formatting (using the normal built-in
Format function) and call that instead.

Ed
 
Back
Top