Report to show n records when date same (1 Viewer)

Hello

hopefully a quick question which can be answered in an easy way

I have a report which is populated by a query for a date which the end user is asked for and inputs

how ever, the table the query is pulling data from has the potential to have two or maybe more entries for the same date my issue is i can only seem to get the report to display the first record ( looks to me like behaves in similar way to a dlookup)

if i add another text box it just repeats further down the report i would like them all clustered together as shown in the attached doc

i would like the data from the picture called "nextrecord" to be displayed in same location as in the other picture

any help would be great

sorry if not been very clear or asking for the impossible

Two questions - What is the SQL query?
Do your records dates have times values in them?

Minty said:

Two questions - What is the SQL query?
Do your records dates have times values in them?

Click to expand...

SQL for query

and no the records don't have time values just the date

If your [AM When] field is just a date with no time, why is it called [AM When]?

Also do you need date delimiters

To add to Ridders observation, I would say looking at those field names this doesn't look like very normalised data structure.

If you have a lot of event timing going on you would normally store the EventType and the EventDate in a separate table. This way you can have as many or as few events as required.

Create a subreport for each HEADER, general, sick, helpdesk, hbw. And put it in the report. You will need to create query for each.