Search results for query: *

Is anybody knows if Access has something like Oracle using in SQL 'Order By Decode..'. What I need to do is order records the way I want not ASC or DESC.I want first with the value 1 then 3 then 2. Thanks

O! i know what you were trying to do. I did try but I'm getting to tired I will try tomorrow. Thanks again!!

I lost you, I'm trying to do second part, where you want me to put Text13?

Thank you so much for trying to help me!!! Monika

I guess I will do queries and then do DLookUp for each Totals

It has to be like that in Main Report: Subreport1: Company name Comments Company name comments Subreport2: Company name Comments etc.... Subreport1 : Total Value Subreport2: Total Value etc....

Tom, Would this work if I put the text box in the vb code in main report; Total_Report.value = CRTS_BusinessC_OwnChSubreport.Report!Total_Sub Total_Report.Visible = True p.s I will try to do now

No, nothing

Also when I run main report I see the numbers correct, but I do not see that number in report footer in main report. it must be something how I refer that text box in main report in report footer

yes, In subreport, I have two records and I made the text box that calculates visible = true so I see it's counting and the text box from report footer shows number 2 as it should

What else I can tell you, the main report has 9 subreports, so for each subreport I have to get a total, so I'm trying for first one to get work, so I can do rest of them

=[Sub_Ownership]

Do I have to change any properties for these text boxes or anything like that?

I tried that even before you mentioned and I tried again now and still nothing

Tom, When I'm running the main report with text that has control source: =[CRTS_BusinessC_OwnChSubreport].[Report]![Total_Sub] then if I look at the text property Access change the text control source without brackets

i'm thinking is somtething with refrences on the text box in the main report, any clue?

I see the correct value in subreport and if I run the main report the value is correct in the place where subreport is, so calculation is correct

I tried it doesn't work

Tom, In subreport there are many records, so I need the total where field name C_OwnershipChange = -3

I tell you want more time what I did: Subreport - CRTS_BusinessC_OwnChSubreport Text Box in subreport in Report Footer - Total_Sub and has the control soure =[Sub_Ownership] where Sub_Ownership is the name of the text box in the same subreport detail where control source is...