Report

[Guest]

I have solved one problem thanks to your precious help..maybe you can help me
again...My database is about instrument calibration. I have two tables :
Instrument and Calibration. And I have one form with a subform for the
calibration data entry. My problem now is the user wants a report with the
next calibration, instrument ID etc. When I use the report wizard, it builds
the report nicely except it will show every calibration date in the field
"next calibration", meaning that if one instrument has had 6 calibration to
date it will show all of the 6. Is there a way I can build the same report
but where I can have only the last "next calibration" date? I hope I make
sense...%-)

Thanks!

 

[Guest]

Hello out there...can anyone help me?? Please??

 

[Duane Hookom]

Please provide some sample data with table and field names. Then provide how
you would expect these to appear in your report.

 

[Guest]

I have these two tables:
TblInstrument:
InstrumentID,Location,Description,FileNo,CalInt,CalType
TblCalibrations:
LastCalDate,NextCalDate,TechName,Comments.

I also created a form showing by Instrument with a subform for the
calibrations.

What I want my report to show to the user is the "NextCalDate"by month,
InstrumentID, Location and Comments, but only the last date entered in the
field "NExtCalDate". So when I run my report, it is exactly the way I want it
to show, but instead of showing me the last date entered in "NextCalDate" for
each record, it gives me all of the dates entered in "NextCalDate" .Does it
make sense?

 

[Duane Hookom]

Select field from a table containing both tables. Make this into a totals
query and group by the field in tblInstrument and set NextCalDate to Max?