...

[jazsriel]

...

 

[theDBguy]

Hi. Welcome to AWF!

Try looking for a sample db using a UNION query in one of the threads here. I'll post a link, if I find one later.

Sent from phone...

 

[theDBguy]

Hi,

I have read about those but I do not know how to do a union on a query. The help that was provided on those I read did not make sense to me. But if you have some that are dumbed down for someone like me I would appreciate it.

Could you post a sample copy of your db with test data? Maybe it would be easier if we could show you how to do it.

 

[theDBguy]

Hi,

I did in the original post.

Thank you

Oh, sorry. I'm on my phone and didn't see it.

 

[arnelgp]

you only have 28 lines on your report?
see the Open event of the report and adjust "intLinesPerPage".

 

[arnelgp]

You copy the dummy table to your db.
In my demo open the report in design view.
Press alt-f11 and copy the code from the report.

Open your report in design view and paste the code in vba.

 

[arnelgp]

its complicated now with those blank lines in-between.
i did not elect to use Group since, doing so will add a blank
line on the beginning of the report.

i added yet another query. it just count how many records per date.

also, your report, if fully filled has 37 lines not 34.
you adjust the botton margin so it will show 34.