multiple records in footer?

[mejia.j88]

Hello Access Tamers,

I am creating a report with a query record source that pulls from 3 tables.
the records that it pulls from table 3 should should be displayed on a footer, in my report. this can be anywhere from 1-5 records, that have one thing in common; their entries in the field [etch_lot]. what seperates records as unique in this table3 is their Test_Date.

is there a way to include multiple records in a footer?



thanks guys/gals

-jm

[pbaldy]

Not directly, but you can put a subreport there that displays those records.

[mejia.j88]

Thanks Pbaldy, I think a subreport will work just fine.
Aside from a subreport, do you know of other indirect ways of doing something like this?

[pbaldy]

Not offhand. The detail section is where you normally have data like that. Footers don't repeat for each record.

[mejia.j88]

the issue I'm having is the following:
i am making a report dealing with part measurements from a specific lot, call this lot EAA####. these are entered into a table called "AfterEtchMeasurement" and a record is created for each measurement, so there could be anywhere from 1-15 records with the same lot number but different measurements.

after the parts go through the whole testing process, their testing yield is added to a different table, in which there could be anywhere from 1-3 records containing this information. our tester can only handle groups of 500, so if a lot has 1700, there will be 4 records made.

when i view my report, these 4 records (that have the same Lot number EAA####) get paired with the 15 records from the previous table.

ideally, i would want to display those 4 records in a footer; but i'm getting 15 repeated entries (15 repeated entries using all 4 records, not just one) if i put them in details; if i put fields in a footer, i only get 1 entry and not all 4.

i hope this makes at least a little bit of sense.

[RayMilhon]

Not sure if this is what'll work for you but I had a similar requirement.

In the report doesn't matter if it's at the report level or group levels. Click on the format Event.

Create a private string variable.

In the detail under the format event include the following code
also make sure that the detail section has Visible set to no. Place the field in the detail section.

If instr(1,strvar,me.fieldname) = 0 Then
strvariable = strvariable & me.fieldname
End if

You will need to add some kind of separator in the strvariable = line above otherwise you will get something like string1string2string3 depends on your needs

in the footer create an unbound textbox then in the format event of the footer put in

me.textbox1 = strvariable
strvariable = ""

first line puts the string into the textbox
second line clears the string