#Name?

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
 
E

Edward Paine

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Seconds to Hours, Minutes, Seconds 3
Sum time calculation in section footer of report 1
I have a strange data mismatch error 4
Converting decimal time into hh:nn:ss time in ACCESS 10
Excel Convert Datetime Stamp to HH and MM Worked 7
HELP! I need to make an IF Statement comparing date/time fields.. 2
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm 1
Adding Times 7

Top