I am building a database in access 2000 that looks at phone bill records. To generate a bill I just use a form with criteria on it including the phone number, customer name and start and end date then this is passed to a report that uses a query as it's source.
The stLinkCriteria of the OpenReport function looks something like this (sorry I don't have exact syntax but am just at work at the moment...)
stLinkCriteria = "[Customer Name] = '" & Me.CustomerName & "' AND [Unit Number] = '" & Me.UnitNumber & "' AND [date] between # " & Me.StartDate & "# AND " & Me.EndDate
So, this is all working fine however I need to show these start and end dates on the report that are specified on the form. The closest I can get to it at the moment is by using a =min([date]) and =max([date]) on some text boxes however this doesn't give a true reading as it only shows the date of the first and last call within the specified range from the form.
Is there a way of showing the actual dates specified in the form and stLinkCriteria on the report?