Hi,
I have a new problem. I have a form (frmDE) that has its field where I input the data, which goes into a query (qryDE) and stored on a table (tblDE). Now comes the problem on my report (rptDE), how do I automatically insert a blank line in the report if a new date is started on the form?
So basically on my form, I input lets just say 3 Nov 2020, 4 Nov 2020, and 5 Nov 2020. Then when I print preview the report I would like to have it show the following:
3 Nov 2020
-blank line here-
4 Nov 2020
-blank line here-
5 Nov 2020
etc....
Any ideas? I have scoured everything I can and I am thinking it will come down to something in conditional formatting, but I do not know how to write the expression, unless I am entirely in the wrong ballpark.
Anyway thank you in advance.