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:
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:
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
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:
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
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