Query to show last records from and all date between records

[Dal Jeanis]

That SQL will make a pretty good guess, but it's not perfect. Here's the operative quote -

I also made the assumption that, if the dates are the same between different plantlocation records, then any one of them will do. If instead you want the record with the lowest or highest ID, then you can change "First(tP1.ID)" to "Min(tP1.ID)" or "Max(tP1.ID)", respectively.

Having an accurate report is going to depend on straightening up the data entry situation.

If you have what you need, please mark the thread "solved". Top of page, under "thread tools". If you come up with other questions later, it's better to start a new thread.

[asoe209]

thanks so I just have to make that small change to the sql to take the largest record id to get be sure that it pulls the right record.

what I will do is make changes to the sub form and just make it have one date rather than to dates. callining it MovementDate or some thing alone them line. I was using the db all day today and for this the 2 dates are not really needed. but im sure i will have more questions once I do that.

thanks again its been a big help.

[Dal Jeanis]

You're welcome. Please mark thread solved.