Text Box controle problem in report

[taahir321]

Hi Dears,



I have been tryieng to put following code in a text box controle in a report footer but it generates error message "#error". Can someone help me out of this trouble!

Best regards,


Tahir



=Sum(IIf([StrM]>[EndM],IIf([StrH]>[EndH],(((24*([EndDate]-[StrDate]))-(([StrH]-[EndH]))-1)),(24*([EndDate]-[StrDate]))+(([EndH]-[StrH]))-1) & "." & (60-([StrM]-[EndM])),IIf([StrH]<[EndH],(((24*([EndDate]-[StrDate]))+([EndH]-[StrH]))),(24*([EndDate]-[StrDate]))-([StrH]-[EndH])) & "." & ([EndM]-[StrM])))

[Robeen]

Try this:

Start again and build your string one piece at a time and see if you get an error at each step.

Also - try & see if each part of what you are trying to display in the textbox is correctly displaying.

I suspect some confusion in the number of parentheses. I counted and the open parens & close parens were not matching in number.

Is your textbox large enough for the data?

[taahir321]

Thanks!
I will try your suggession

Best regards,

Tahir

[taahir321]

Hello!
Hope you are fine. I am attaching a database. in it please open report RSputt and see error in the report footer.

in fact i have been developing an equipment log where with the hepl of (start date ---start time ) and (Enddate ---End time) running or usage time of an equipment is calculated. I have submitted just the relavent portion of the database. Please see and help me find a solution to this problem.


Best regards,

Try this:

Start again and build your string one piece at a time and see if you get an error at each step.

Also - try & see if each part of what you are trying to display in the textbox is correctly displaying.

I suspect some confusion in the number of parentheses. I counted and the open parens & close parens were not matching in number.

Is your textbox large enough for the data?

[Robeen]

Did you try this:

Start again and build your string one piece at a time and see if you get an error at each step.

??

[Robeen]

Taahir,
In your =Sum . . . expression, can you describe to me what will be displayed if the expression is True and what will be displayed if the expression is False?

[Robeen]

Try this in your Text Box:

 
=IIf([StrM]>[EndM],IIf([StrH]>[EndH],(((24*([EndDate]-[StrDate]))-(([StrH]-[EndH]))-1)),(24*([EndDate]-[StrDate]))+(([EndH]-[StrH]))-1) & "." & (60-([StrM]-[EndM])),IIf([StrH]<[EndH],(((24*([EndDate]-[StrDate]))+([EndH]-[StrH]))),(24*([EndDate]-[StrDate]))-([StrH]-[EndH])) & "." & ([EndM]-[StrM]))

When I ran the report with that - the Text Box displayed 745.57.

Let me know if this is what you needed.

[Robeen]

Is this solved?