splitting a report

  • Thread starter Thread starter James
  • Start date Start date
J

James

Is there anyway to split and export a report by group headings?
I have a database that contains 20 names, I really need a way to export the
data from the table/report into separate excel files. any ideas?

TIA
James
 
It seems easy enough to either use the WhereCondition argument of the
DoCmd.OpenReport to add a criteria that specifies the value of the desired
group(s). Alternatively, and perhaps more responsive, would be to create the
complete SQL including those criteria, pick it up during the Open event of
the Report, and use it to replace the Report's RecordSource property.

Larry Linson
Microsoft Access MVP
 
thanks for the response Larry!
unfortunately I am very inexperienced with Access, so I'm still lost. :-(
If you have time, could you try to explain this in more detail? I will try
to start with what you already sent and see if I can get any further.

thanks again!
 
Back
Top