... (1 Viewer)

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:54
Joined
Oct 29, 2018
Messages
21,358
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

I’m here to help
Staff member
Local time
Yesterday, 21:54
Joined
Oct 29, 2018
Messages
21,358
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.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:54
Joined
May 7, 2009
Messages
19,169
you only have 28 lines on your report?
see the Open event of the report and adjust "intLinesPerPage".
 

Attachments

  • DB.zip
    692.6 KB · Views: 145

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:54
Joined
May 7, 2009
Messages
19,169
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

..forever waiting... waiting for jellybean!
Local time
Today, 12:54
Joined
May 7, 2009
Messages
19,169
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.
 

Attachments

  • db (1).zip
    704.9 KB · Views: 125

Users who are viewing this thread

Top Bottom