Query String on a Report

  • Thread starter Thread starter Chefjay22
  • Start date Start date
C

Chefjay22

Hello there! I have a quick question. I have an unbound field on a report
that needs to display a max value from a table. Here is my example:

ReportName: rptTest
unbound field: MaxDate

I need to query tblDates and grab the max record in field StartDate and
display it in the unbound field MaxDate. I know how to do this using a
subreport based off a query, but I would like to learn a new way... any
ideas? Thank you!
 
Chefjay22 said:
Hello there! I have a quick question. I have an unbound field on a report
that needs to display a max value from a table. Here is my example:

ReportName: rptTest
unbound field: MaxDate

I need to query tblDates and grab the max record in field StartDate and
display it in the unbound field MaxDate. I know how to do this using a
subreport based off a query, but I would like to learn a new way... any
ideas?
Click to expand...

How about just using an expression in the text box:

=DMax("StartDate", "tblDates")
 
Hello there! I have a quick question. I have an unbound field on a report
that needs to display a max value from a table. Here is my example:

ReportName: rptTest
unbound field: MaxDate

I need to query tblDates and grab the max record in field StartDate and
display it in the unbound field MaxDate. I know how to do this using a
subreport based off a query, but I would like to learn a new way... any
ideas? Thank you!
Click to expand...

In an unbound control:

=DMax("[StartDate]","tblDates")
 
Back
Top