Solved Report Header Calculated Fields (1 Viewer)

LGDGlen

Member
Local time
Today, 01:42
Joined
Jun 29, 2021
Messages
221
Hi All

I am creating a report that shows a limited selection of records and the details section is now pretty much set but i need to add a little bit of summary information in the report header as follows:

1639492278964.png


I want to gather the first and last dates from the listed records and show a to and from in the header.

My question is do i need to:
  • take the query that creates the data and create 2 separate queries
  • query 1 has only 1 field, delivery date, and picks top 1
  • query 2 has again only 1 fields, delivery date, and picks the last date
Then i add these 2 new queries to the report query and create a calculated field that contains the 1 field from both queries

Is that right? happy to be wrong but i'm thinking thats the way it should be done, but how would i link the queries to that in the report if there are no IDs or anything? this is where i'm a bit confused

Thanks in advance

Glen
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 17:42
Joined
Oct 29, 2018
Messages
19,167
Hi. You could try this first. Use an unbound Textbox and enter the following in the Control Source.
Code:
=Min([Delivery Date]) & " - " & Max([Delivery Date])
Hope that helps...
 

LGDGlen

Member
Local time
Today, 01:42
Joined
Jun 29, 2021
Messages
221
@theDBguy yass, i'll give that a go thank you
 

Users who are viewing this thread

Top Bottom