Most recent record in a subreport

G

Guest

I have a report and subreport. The report has some information from a
tblProject. The subreport has information from tblDiaryNotes. What I want
the subreport to display is only the most recent diary note. I have tried to
create a query that uses TOP or DISTINCT without success. Also tried to
create an SQL recordsource in VBA by using the project number from the main
report.

"SELECT TOP 1 tblDiaryNote.ProjectNo, tblDiaryNote.Note from tblDiaryNote
where tblDiaryNote.ProjectNo = " & strProject

I put the ProjectNo value in strProject before running. Problem is that if
I use it with the on open it only displays the first project number records.

I need a bit of lateral thinking here. There must be a solution but I am
just too buried to find it. Can anyone help?
 
D

Duane Hookom

You might be able to add a text box to the detail section of the subreport:
Name: txtSeq
Control Source: =1
Running Sum: Over All
Visible: No
Then add code to the On Format event the subreport detail section:
Cancel = Me.txtSeq >1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom label in subreport 1
Apply a Filter to a Subreport 2
Subreport filtering 1
Multiple Pages in a Subreport 1
Printing Subreport without data 2
Using subreport result in expression 2
Show last record in subreport based on ID 2
keeping a subreport label and subreport together 2

Top