Need help so much… I just can’t

[chile19]

Hey guy’s, I been working on this problem for 5 days already and I cant get it to work.

The thing is that I have a Main Report with 2 Sub Report, and I have to do some calculation, but I get error all the time.

I try to use Nz(), iif(isNull(),,), etc. and nothing.

Pleas help.

Here are some images so you can get to the report, and also is the Data Base.

Thanks a lot.

Rafael from Chile

the access file is on :
www.mi-pagina.cl/mekota/Inversiones.zip or
www.mi-pagina.cl/mekota/Inversiones.rar

 

[Ukraine82]

I suggest you give us more information on what you want us to help you with. I know you're trying to get the total for something, but give us the field name, report name, and/or subreport name.

We need a better explaination on exactly what you need. Maybe myself or others can help you out.

Michael

 

[chile19]

come on!!!! any ideas???

 

[chile19]

You are right ukraine84. The Main report is “RESUMEN_OP_FIN” an the sub report are “Subinforme COLOCACION_PESOS” , “Subinforme COLOCACIONES_DOLARES” and “Subinforme FONDOS_MUTUOS_PESOS”.

On the main report, the textbox “Texto58” needs to be fix, so the rest can be fix.

I realize that in the recodsource from “Subinforme COLOCACION_PESOS” there are no result at all. Not even empty ones.

 

[Rich]

Search here for the HasData method, examples have been posted

 

[chile19]

I try to used to, but it do not work.

 

[Rich]

post an example of the syntax you tried

 

[chile19]

on the main report. on th onactivate event:

If Me.Subinforme_COLOCACION_PESOS.Report.HasData Then
Me.Texto58 = [Informes]![RESUMEN_OP_FIN].[Informe]![Subinforme COLOCACION_PESOS]![suma_tasa*monto]
Else
Me.Texto58 = 0
End If


and i get error.

please help!!!

 

[Rich]

I'd rather use the control source of the textbox than vba.
something like
=IIf([subReportName].[Report].[HasData],[subReportName].[Report]![subReportTextboxNameName],0)

use the code builder to get the correct sytax for your subReport and textbox name

 

[chile19]

thanks man, it works, and you save me!!!

 

[Rich]

now you can enjoy the warm sunshine whilst we perish in the cold