I would show previous deliveries in a Subform sorted descending by date or you could get the previous delivery using the DMax function based on the date of the delivery.

We would need to know more about your database (including screenshots) to give you more detailed advice.

The 1st screenshot is of my main table. It contains everything. The load # is from the table Loads. The 2ns screenshot is of my final report after all results have been entered. It displays the load #'s, results, and if the load has been flagged for being too high and which flag it is (1st, 2nd, 3rd). The 3rd screenshot is the entry form for the final results. This is where I need to figure out how to show the previous flag to know what to assign. Example the result that is 186 is this trucker's 1st flag, the result 194 is that trucker's 3rd flag and has been automictically suspended until cleared by management. How this helps!

On each load you will need a truck number or a unique way to identify it, then you can use it to filter the data in a query by this Identifier and sort by date.

I shall see if the dmax function will work. Thanks!

How would I implement the DMAX option for each line of my PI-Results Filter?

If you have not yet watched this video, please do so.
DMax
There are three parts to Dmax:
1)What Data are you retrieving (Last result)
2) Where you are retrieving it from (The table)
3) The WHERE condition (Which records to check)

You could build a Query with a Calculated Field that implements the DMax function then base your Continuous Form off of that Query to show the results you want to see.

Kevin, how would I do that? I tried to do a new form based on a new query that filtered the loads that were above the threshold and then do the dmax like he shows in the video but it just gave me an error message.

=DMax("Flagged Loads","Load Log","Previous Flag"="& Flagged_Date)

Remember: Dates should be enclosed in #.

=DMax("Flagged Loads","Load Log","Previous Flag"=#"& [Flagged Date] & "#")

Advice: It is advised not to uses spaces or special characters in field or object names.
If spaces are used make sure to enclose the field name in square brackets.

=DMax("[Flagged Loads]","[Load Log]","PreviousFlag=" & [Date])

I'm trying a different approach. I created a new form based on a new query that filtered the high loads for that date and then added the Dmax for Previous Flag. But it keeps giving me a #Error message. It should be showing me 2nd since this particular load is currently on its 3rd and has been suspended. New code above.

Sorry. I didn't notice the extra double quote after Previous Flag.

=DMax("[Flagged Loads]","[Load Log]","[Previous Flag]=#" & [Flagged Date] & "#")

Have you name one of your fields Date? This is a reserved word (it is the name of a function that returns the current date) and will cause you many problems in the future. I advise renaming the field. As an example: OrderDate

Additional advice: I recommend working your way through Richard's classes. You appear to be missing basic knowledge of proper database concepts.

I got the #Error to disappear but I'm still not getting the previous flag. :(
Here is the code so far:
=DMax("[Flagged Loads]","[Load Log]","PreviousFlag=" & [Load #])

It has been about 10 years since I took Access in college. I remember some things but I have been working through the classes to refresh my memory. I don't remember using DMax in my college course so it is rather new to me.

If you can, rename your fields in your table. Get rid of spaces and non-alphanumeric characters from your table and field names. They're going to cause you pain in the future - if not already.

What type of value is that Load# field? From the tiny bit I can see of one, it looks like a text value and it looks like you might even be using a Lookup Field (another big no-no). If it's text, you need to enclose it in quotes inside the DMax.

=DMax("[Flagged Loads]","[Load Log]","PreviousFlag=""" & [Load #] & """")

If it's a lookup field, you're SOL.

And yes, I would strongly recommend you watch the Beginner and Expert classes - as many as you can. I cover a lot of fundamentals on how to construct your database... like not using spaces, string concatenation, and things like that. Remember, if you build a house on sand, it doesn't matter how pretty that house is... if the foundation is weak, you're going to have issues.

Thank you for all of your help! I was able to remember how to insert a table based on a query into my FlaggedLoads_F, which you can see in the screenshot. And I had totally forgotten about the no space rule until you mentioned it in one of your videos. I've been slowly working my way through them. The Load_# (See! No space! :) ) is based on a lookup from the Loads table. I have 100+ trucks to track and it seemed the best way to do that when I started this project. It was suppose to be a simple database for me to track results but my QA manager asked me to make it user friendly for the other techs in my lab.

I hate to ask anymore of you guys, but my manager has asked me if it would be possible to add the load # into the email subject line when we email the reports. Is this possible? I know that there is probably some sort of VB code but I'm not proficient in VB. I've been using Macro Design to have the email generate with a click of a button. I then have it set up to allow editing so that I can add the load # manually. Thank you for all of the help you have already given, and for any additional help you can provide.

Start the subject line with an equals sign, enclose any static text in double quotes and concatenate your field value.

Example:
    ="Your Text Here " & [Forms]![YourFormName]![YourFieldName]

Concatenation
Value From a Form