Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

newbie - 21 Sep 2005 21:25 GMT

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!

Reply to this Message

newbie - 22 Sep 2005 15:49 GMT

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

> 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 :
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

Duane Hookom - 22 Sep 2005 18:50 GMT

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

Signature

Duane Hookom
MS Access MVP

>I have solved one problem thanks to your precious help..maybe you can help
>me
[quoted text clipped - 11 lines]
>
> Thanks!

Reply to this Message

newbie - 22 Sep 2005 20:47 GMT

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?

> Please provide some sample data with table and field names. Then provide how
> you would expect these to appear in your report.
[quoted text clipped - 14 lines]
> >
> > Thanks!

Reply to this Message

Duane Hookom - 23 Sep 2005 03:33 GMT

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?

Signature

Duane Hookom
MS Access MVP

>I have these two tables:
> TblInstrument:
[quoted text clipped - 41 lines]
>> >
>> > Thanks!

Reply to this Message