I'm displaying DB records on screen through the loop command.
There are different dates on screen for one of the fields and I would like to be able to group these in order (that's done... no problem through SQL) but then look at the records and on every group display the date for that group at the top of that table.
So, as it loops check the date and ask whether the previous record date entered is the same or different... if different then display it and carry on displaying the records in that date range until the date changes again and so on. In the end there will be a date, records in tables for that date, a new date and records in tables for that date and so on...
Is this possible/easy to do?
There are different dates on screen for one of the fields and I would like to be able to group these in order (that's done... no problem through SQL) but then look at the records and on every group display the date for that group at the top of that table.
So, as it loops check the date and ask whether the previous record date entered is the same or different... if different then display it and carry on displaying the records in that date range until the date changes again and so on. In the end there will be a date, records in tables for that date, a new date and records in tables for that date and so on...
Is this possible/easy to do?