Search results

Help? :o

Hmmm... YEAR is defined as a string but I tried both of those codes... When I view the report both codes gave me a #Name display on the box (what does that mean?). Also the code seems to change to this after I view it: =DSum(" [GRADES] * [ACT CREDITS] ",Forms![INDIVIDUAL APR]!BOX2,"[YEAR] = '"...

Is subreport just simply showing up the report that's linked to? Why do I need to reference the control? I'm changing the control source for the individual reports.... is there's something I'm doing wrong? :confused:

I think you could use the "subreport" function.... so create 1 report and use the subreport to link your existing reports.

Changed it to: =DSum(" [GRADES] * [ACT CREDITS] ",[Forms]![INDIVIDUAL APR]![BOX2],"[YEAR] = REPORTS![Main Report]![APR REPORT YEAR1].REPORT![YEAR] AND ([GRADES] LIKE '[0-9]*' OR [GRADES] = NULL )")/DSum("[ACT CREDITS]",[Forms]![INDIVIDUAL APR]![BOX2],"[YEAR] = REPORTS![Main Report]![APR REPORT...

So instead of REPORTS![APR REPORT YEAR3]!YEAR Change it to... REPORTS![Main Report]!APR REPORT YEAR3.Report![APR REPORT YEAR3]!YEAR ?

Having some wierd report display on my report... Basically I have a main report where 6 reports are linked to it by using subreport. On these 6 reports there is an area for displaying annual average (database for school). The calculation code used: =DSum(" [GRADES] * [ACT CREDITS]...

Hmmm filter seems to work with my reports... But when I use the subreport properties to show these reports on a main report page, Access complains about the filter conditions.... " The setting you entered isn't valid for this property" Any idea why? :confused:

Help?

Not sure if this is the place to post this since the question/problem involves filter, query, report, and VB... :o Ok I have a database which contains bunch student records in different years. So a report on student progress can be 1-5 pages long. Before I was trying to manipulate the display...

Nm I got it. :p It's Me.Filter="GRADES < '50' " :D

Hmmm so if I use OpenReport I can limit to which page I want to view? (not print, view). Tried using filter again but doesn't seem to work.. I did: Private Sub Report_Open(Cancel As Integer) Me.RecordSource = Forms![INDIVIDUAL APR]!Box2 Me.Filter = GRADES < "50" Me.FilterOn = True End Sub...

The report can range from 2 - 6 pages. Ok I found a way to do this by using filter....but I'm not very good with VB coding...please help. Right now the code is: Me.FilterOn=True Me.Filter = " conditions/criterias " In the table that the report reads, there are fields such as YEAR, REQ...

Sorry it's just nobody is answering my question... Link is here: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44809

I posted the following question on Report Forum: Say I have a report that's 10 pages.... is it possible to display only a certain page (ie page 2 only) on the report view? If so how could I do this? Someone said: There is a Pages Collection which has Page as the Object ... and then you can...

Bump. HELP? :confused:

Bump!

Where is "Pages Collecction" under? I can't seem to find the control anywhere. :o

Hmmm? :confused: :confused: :confused:

Bump. Help? :confused: