Reports ??? Help!

[Vikki]

Stuck again



For shelf life analysis

I am attempting to create a database where we create a sample ID (used Auto number) and also input date produced and size of unit. This I have done using a form.

Each sample is then checked each day. The samples are graded from 0 to 3.
0 being ok,
1 off,
2 very off,
3 rancid.

Instead of having to enter a zero, I was hoping just to enter when the results are positive, using a form to enter data on a new table showing Sample ID, Dated Tested and Result.

This is all working well. I have Created a subdataform in the Sample entry table with the results table.

My problem is now extracting the data to show the number of days to the first positive test date for each batch indivadial sample.

I can create a report but this shows all the results for each sample and I just want the first day that is positive,

Also I need to beable to calculate the % of batch (production day/ size) that has a positive result.

If anyone understands this I'll be amazed . But I would be very greatful for any assistance.

Thanks

[cowboy]

Try a query or vb code that loops until true and then exits sub from there.

[NTC]

do a query for value 0 - that gives you just the ok records. call this QueryOK.

then make another query - using QueryOK as the source - and make it an aggregate query ....look for the epsilon greek E icon....set it to GroupOn Sample and set the date field to Max.

[Vikki]

I'll give it a go! cheers.