Hello all,
I have inherited a database that we have been using for a long time because the person who designed it retired, and I'm the only other person in our company that *somewhat* speaks Access.
We have one report that when it prints, it only fills the top half of the page and we end up cutting off the bottom and wasting paper. I wanted to change it so that the report would print 2 of the report pages per page, without using printer settings as our printer does not do duplex and it would not be practical to manually flip the sheets due to the location of the printer relative to our computers. I have an image of this attached (print preview) with the red text being what we would like to see.
I have also included a screen shot of the design view for the print preview as it currently is.
I really am not sure where to go from here. I have some basic VB knowledge, and have made a few fairly simple databases myself, but have no formal training in the area. Any help or suggestions would be greatly appreciated.
Thanks!
I have inherited a database that we have been using for a long time because the person who designed it retired, and I'm the only other person in our company that *somewhat* speaks Access.
We have one report that when it prints, it only fills the top half of the page and we end up cutting off the bottom and wasting paper. I wanted to change it so that the report would print 2 of the report pages per page, without using printer settings as our printer does not do duplex and it would not be practical to manually flip the sheets due to the location of the printer relative to our computers. I have an image of this attached (print preview) with the red text being what we would like to see.
I have also included a screen shot of the design view for the print preview as it currently is.
I really am not sure where to go from here. I have some basic VB knowledge, and have made a few fairly simple databases myself, but have no formal training in the area. Any help or suggestions would be greatly appreciated.
Thanks!