Show only last record in query

[robsworld78]

Just so you know, this issues popped up again, as more data went it it stopped giving me the last bin number and this time it was really only pulling the highest bin number instead of the last and I was using the "Last" on the Totals Row in the query.



I went back to the DLast in the criteria with no totals and that works! This turned out very useful after all.

[boblarson]

Just some info for you robsworld -

The data in Tables are not stored in any particular order by Access.

Last() is unreliable (and is documented as such by Microsoft and other Access pros). It will actually only give you a random record, not the last one entered. If you want the actual last record entered you need to use DLAST as has been pointed out. But the key is using the proper criteria. You can also use a query that has the criteria and then using DLast on it will yield the one record that was added last from that set of records.

[robsworld78]

Thanks Bob, I thought they were defaulted to the autonumber field but I guess it seems that way because its always the first field as it works out.

Good to know about the LAST in totals being wrong, I'll avoid in all situations.

Is it only Last that doesn't work properly or does FIRST have the same issue?

I have a LAST somewhere else on one on my queries, I'll have to find and change it.

Have you heard anything about what I mentioned, the "D" functions don't work on the executable file type?

[boblarson]

Last or First can be okay as long as you don't require something specific. It can also be helpful in a crosstab instead of aggregating you select first or last.

I've never heard anything about not using the Domain Aggregate Functions when using the runtime. By the way, don't use "executable" because an Access database is NEVER an executable. There is no way to turn it into an executable file. There is at least one website out there that claims to be able to do so, but it turns out that it isn't really such. There is a bunch of "trick" stuff going on to make it SEEM like it is. But it isn't.