Statistics via a subreport?

  • Thread starter Thread starter B Nieds
  • Start date Start date
B

B Nieds

Hi:

I have created some reports which provides varying information on inventory
items consumed in different projects. The reports are working fine but I
wanted to add some statistical information. Information like Count of
projects in report, Total $ value of group of inventory items, Date of
consumption, and so on grouped differently than the main part of the report.

There are two files which has the information I want. File one (I'll call a
header file) contains overall information similar to a sales (this is all
internal consumption) invoice. The second file (I'll call a detail file)
contains specific information with one field providing a unique link to the
header file.

The report starts by listing all the header information and generates the
required totals. What I then want (I put this in the Report Footer) is a
summary of (grouped differently than the information I just printed) the
header information. Since I could not figure out a way to do this without
destroying the information just printed, I created a subreport and placed
this in the Report Footer which Access is complaining about. "..database
engine could not lock table Header because it already is in use by another
person or process..." On my test system I have sole access to the file and I
shut down everything running except for the report.

So question 1: Is my approach of using a subreport a valid way of doing what
I want to do?

and question 2: How can I tell Access not to lock the table?

Thanks
Bill
 
If you get an error message like this in a report, it might be caused by
corruption. Have you tried compacting and repairing?
Your subreport sounds like the best method since the record source is
different from your main report's record source.
 
Back
Top