Report detail and line spacing capabilities
This seems to be the best I can do. It's close together but I was wondering if I could get it closer. This may be all that Access will allow me to do. Am I right? If so,I can deal with it but just wanted to know if there was anything else I could do.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The information in the detail section is description for an invoice. It could be 1 or many lines. In the report footer section are the totals for the detail section, sales tax, sub total, invoice total.
it prints ok when we have just one line in the detail section, but when more then one line, it moves the footer section down
Or is it easiest to just create two reports, one with the Detail section visible and one with the detail section not visible?
I would like to dynamically expand the vertical size of the details section to only show the required space to show all 15 lines in the memo field, so that if I had 3 detail lines as so:
detail line 1,: memo field has 15 carriage returns
detail line 2: has 1 carriage return
the detail section will really only be approximately 16 lines in height not 30.
I've created queries to pull the "day" from each date serviced, and by month. I do have the days showing in the appropriate month column on the report, but I need for them to all start at the top of the detail line. Kinda hard to explain. But essentially my report is looking like this:
However, after the first time the detail section needs to grow (which it does OK) it does not shrink back for other records displayed in Detail section. LIne height is changing as it should,but not Detail section height.
I have GroupHeader1. It Can Grow.
I have GroupHeader2. It Can Grow.
I have Detail. It Can Grow.
The layout results in:
GroupHeader1 | GroupHeader2 | Detail Item1
GroupHeader2 | Detail Item1
GroupHeader1 | GroupHeader2 Detail Item1
The report requires a horizontal row at each Detail Item.
Detail Items may vary in height.
GroupHeader1 Items may vary in height.
GroupHeader2 items may vary in height.
Here's the tricky part: At all times the height of GroupHeader1, GroupHeader2 and Detail Item MUST be the same WHICH EVER IS THE GREATEST AMOUNT.
Otherwise what happens in the horizontal line of Detail may cross through the verbiage of GroupHeader1 or Groupheader2.
The width of the textboxes cannot be adjusted further.
I have a 2nd table, called Payroll Detail. Within this table exist the detail payroll data by employee by segment that totals line consolidated line by segment in Data1.
I'm trying to create a query or something that allows me to combine the two sets of information. I need to include some data that is in Data1 and not in Payroll Detail table. However, instead of my results showing the consolidated line by segment, I want it to match up some criteria and give me the detail by employee by segment from Payroll Detail table.
So in otherwords, I want it to replace one line from one table with several lines from the 2nd table.