View Last Report Only.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI

I made big DB everything is working alright only Viewing last report.
I have the report base on Query and in that query i made all the field Total
as LAST.When i run the query it show the record of the one before last.

Help me please.Thank u so much.
 
Hassan

Your definition of LAST and Access' definition of LAST are probably not the
same.

If what you want is something like the last date (most recent date), use
MAX.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Last or First only have meaning if the records are sorted.

Like Jeff Boyce said, Max or Min are much better especially if you have
something like a date/time field.
 
Even if records are sorted, Last or First don't work
as expected.

If you group, then the sort order of the group has
disappeared. If you then select Last, you normally
get the value you saw as last in the sort before
grouping, but you can't depend on it.

1 a
2 a
3 a

sort by number
select last number grouped by letter
2

when you group by letter, there is no longer a sorted
list of numbers. when you select 'last', you are selecting
from the group, not from the list.

It works as expected 99.9 times out of a hundred, which
is not really good enough to depend on.

(david)

I mean if you try 1000 different queries, not 1 query 1000 times.
 
Back
Top