last record

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Hello
I want to create a report that shows only the last dated record in a table.

Report fields:
ActivityID
Activity Date
Activity Notes
ClientName
Consultant

I want the report to only show the last Activity entered and not all of
them.
Please can you advise.
Ta
Jen
 
You can use the Where condition of OpenReport:

Dim datLatest as Date
datLatest = DMax("[DateField]","[YourTable]")

DoCmd.OpenReport "ReportName", acViewPreview, , _
"[CAR_Date] = #" & datLatest & "#"

The underscore (line continuation character) is optional.

If there are several records with the same Max date you will need to do
something more to specify the record you want.
 
May I suggest you limit this type of response to when Steve acutally
solicits money? There are plenty of opportunities for that. You may be
sending an unintended message to the OP or to new uses of this group that
only responses of a certain caliber are welcome, but in fact all
non-commercial responses are welcome. If somebody posts inaccurate advice
somebody else will likely set the record straight, but people should not
fear reprisals for weighing in with their suggestions and opinions.
 
Thanks everyone. Will try all suggestions.


BruceM said:
You can use the Where condition of OpenReport:

Dim datLatest as Date
datLatest = DMax("[DateField]","[YourTable]")

DoCmd.OpenReport "ReportName", acViewPreview, , _
"[CAR_Date] = #" & datLatest & "#"

The underscore (line continuation character) is optional.

If there are several records with the same Max date you will need to do
something more to specify the record you want.

JB said:
Hello
I want to create a report that shows only the last dated record in a
table.

Report fields:
ActivityID
Activity Date
Activity Notes
ClientName
Consultant

I want the report to only show the last Activity entered and not all of
them.
Please can you advise.
Ta
Jen
Click to expand...
Click to expand...
 
Hi Steve.
I did what you said but unfortunately it didn't work.
Also I think I should have cleared up that I don't just want the last
activity overall but the last one for each Client.

When I tried what you said, it still showed all the records, but sorted by
the Activity Date.

Jen
 
Back
Top