report group line Results


Page 1 of 20.
Results 1...20 of 391

Sponsored Links:



Hi,

I have 2 small problems with my report. I have a list of Clients (header) and a list of factories. Each client can visit several factories, several times. The report template is as follows:

Client 1
usine X
- visit on 10/09/2010
- visit on 07/08/2010
- visit on le 08/05/2009
usine Z
- visit on 10/07/2010
client 2
usine X
- visit on 12/04/2010
- visit on 13/08/2010
usine Z
- visit on 16/09/2010
- visit on 30/09/2010

... and so on

How should I modify my query so that the only most recent visit only appears on the report?

Also, how to force a page-break before a new CLient name. I don't want to have just the client name a t the bottom of one page and the list of factories visited at the beginning of the next page.

My SQL query is :

	Code:
	SELECT tblCLIENTS.Date, tblCLIENTS.Client_ID, tblCLIENTS.Name, tblFACTORY.Factory_ID, tblVISITS.Currency, tblVISITS.Factory,
tblVISITS.Contact, tblVISITS.Comments
FROM tblFACTORY RIGHT JOIN (tblCLIENTS RIGHT JOIN tblVISITS ON tblCLIENTS.Client_ID = tblVISITS.Client) ON
tblFACTORY.Factory_ID = tblVISITES.Factory ORDER BY tblVISITS.Date DESC , tblCLIENTS.Name;


Also one more thing. My CLients are not sorted by name althought I have the "ORDER BY tblCLIENTS.Name". Why??
Thansk for your help

nianko




report grouped by month is skipping months
My report is grouped by month but is skipping some months altogether, as they do not appear in my tables as data. I’m interested then in providing some sort of code (I’m assuming) behind my groups that will determine if a month is missing & then print out a line of null /zero values.

I was thinking along the lines of using a do/while loops or something, am I on the right track?




Hi,

From a report Form, the user selects some criteria to narrow down the report data. So, when calling the report there is a filter.

The report, calls a query with the filter sent to it. It also has a sub-report that shows some total allocations. The detail line consists of account number, comments, prior year allocation, expenses etc.

If there is duplicate data, all fields are the exact same except for 1 field.

Example of Data
Acct. FundingSortCode
----------------------------------
2255 a
2255 c
2255 d
2255 e

This FundingSortCode is not shown on the report, but it is used in the report Form selection criteria. (i.e.: when calling the report it sends ([FundingSortCode] 'a') ).

The report has 2 groupings: Community Name and Project Number.

Since I can't hide the sub-report, I had to put it under the Project Number grouping.

Between each detail grouping is a line. I need to only show 1 detail line.

But, when the duplicates records, the report gets:

line
detail information
line
sub-report information
line

I need to remove the middle line, this line is the first field in the detail section. This is happening because of the dupicate records.

Any ideas?

Thanks so much.

Karen




I have a database, and I am looking to add a somewhat master statistical report.

The database is for candidates that apply at my work, for a job. The statistical report will be for counting who we have hired.

The factors are what department they were hired to, what office, and what candidate type they are.

The db is in 3rd normal form with lookup tables for any "type" or factor that has to do with a candidate. If you are really interested to see the table relationships, see an image here

Anyway, my goal is to have the user enter a beginning and end date for their criteria, which will be pulled from the start date that the candidate was hired.

Then the report would show the statistics for hires during that time period. It would look like the following:

Office Hired to:

New York City - 10
Boston - 15
Chicago - 30


Department Hired to:

Human Resources - 8
IT - 12
Finance - 24
Marketing - 6


Candidate Type Hired:

Administrator - 13
Analyst - 27
entry level - 21
intern - 9

Total Hired Between dateA and dateB: 50

Then I would like to add a chart (time line of hire ups and downs, or maybe bars for each factor, not sure, but I am not worried, because I can usually do charts no problem.)


right now, no matter what I do, I get

office:
New York - 1

Candidate type:
Administrator - 1

Department:
Human resources -

-------------
office:
Boston - 1

Candidate type:
Analyst - 1

Department:
IT - 1

and so on...
for each record.

If anyone can help me to get this to group right, I would really appreciate it.
Thank you.




I have a database that contains a CUSTOMER table, an INVOICE table, an EQUIPMENT table and a LABOR table.

The INVOICE table has a 1 to many relationship to the EQUIPMENT and the LABOR table.

The EQUIPMENT table and the LABOR table are grouped by the ROOM in which the equipment is used and the labor is done.

Petty simple stuff, right!!! Wait

I have a report that looks like this

Report header (design view)
Company information
Room Group
txtArea (this is a field in the EQUIPMENT and in the LABOR tables)
Details
Oty description cost extended (fields from EQUIPMENT table)
GroupFooter
LaborDescription Charge (fields from the LABOR table)
Report Footer
Total equipment Cost (=sum(extended) (textbox name for extended cost)
Total Labor Cost =sum(charge)
Amount paid to date (field in payment table)
Balance Due =txtTotalEquip+txtLaborChge)-AmtoDate

The report should print something like this (print preview expected)
Company Info
Invoice #9999999
Room1
1 EquipA $$$$$ $$$$$
1 EquipB $$$$$ $$$$$
Labor $$$$$$
Room2
1 EquipA $$$$$ $$$$$
2 EquipB $$$$$ $$$$$
1 EquipC $$$$$ $$$$$
4 EquipDB $$$$$ $$$$$
Labor $$$$
Room3
Labor $$$$

Total of Equipment $$$$$
Total of Labor $$$$$$
Amount day to date $$$$$
Grand Total $$$$$$

Reasonable Yes!

Here is the problem.
1 The labor line for Room 3 with labor charge only in that Room does not print
2 The Total Labor charge I can not get to calculate.
I have tried =sum(nz(LaborChge,0) This gives me a number that adds the labor charge for each equipment item in the room group. There is only one labor charge for the Room.

The entire report is based on a query but when I put a sum in the query I get multiple record within the Area equal to the number of labor charges in the invoice. Can not successfully put the sum there.

I have tried several (hundreds maybe) other ways without success. I fell like Edison when he said “I have not failed but I have found 2000 ways it doesn’t work.”

Any help you can give on calculating the Total labor charge and figuring out why the Labor footer within the room won’t print if there was no equipment used in the job..

Anyone that could help would be saving my sanity. Thank you ahead




Our office runs MS Access 2003. I’ve been working on a little database. It’s what you could probably call a “skills” database. A report on the different skill sets is generated from the database and uploaded to the web. Prior to my volunteering to automate all the work that was being done manually people were editing separate look a like word documents, printing to PDF and uploading to the intranet. A lot of it seemed like a waste of time to me. Me and my big mouth.

Up until a short while ago I was stumped as to how I could;

1. Print each group to a separate file, and;
2. Print the files as PDF.
I worked out how to output the reports as RTF (though not separately, but as everyone will no doubt know you lose all your report formatting (lines, graphics, etc) when outputting your report as RTF. It wasn’t good enough.

I hit on the idea of hacking together the code that let me print to RTF and the lebans code that lets you print a report to PDF. This is how I did it;

Ingredients;

Files
dynapdf.dll
StrStorage.dll
And Module modReportToPDF
from http://www.lebans.com/

An access database with a query based report that is grouped on one particular data item. Lets call it DB1.
A form (menu or otherwise) that could hold a combobox and a command button . Lets call it FormA.


Procedure

1. Copy dll files to same folder as the database or system folder as described on http://www.lebans.com/
2. Copy Module modReportToPDF to the module library of database DB1
3. Create a global string variable for use as the individual file names. Lets call it GroupVar

e.g - Global Groupvar as String

4. Create an unbound combobox on FormA. Lets call it cboCombo0
Rowsource Type = Table/Query
Rowsource = SELECT TABLE.iNDEXFIELDNAME, TABLE.GROUPFIELDNAME (IF NOT INDEX FIELD) FROM TABLE ORDER BY [GROUPFIELDNAME];
If Index field is the field your report is grouped on then the bound column would be 1. If it’s a second field then the bound column would be 2.

5. Put a command button on Form A (lets call it cmdReportGen.
6. Open your report in Design View
7. Make a note of the name of the field that displays your group name
8. In the “On Format” event for the section of the report within which your group field is place the following; Groupvar = fieldname
9. Place the following code (appropriately amended) against the “On Click” event of cmdReportGen;

Private Sub cmdReportGen_Click()
'Posted by ADezii 5.23.2009 on bytes.com
'Modified by Gina Whipp 11.4.2009 to OutputTo Multiple Files
'Tested in Access 2003
'Adapted to print multiple PDF files based on report grouping
'and save files named for report groups - Stephan 15 September 2010

Dim intCounter As Integer
Dim cboCode As ComboBox
Dim blRet As Boolean
Dim stDocName As String

stDocName = "ReportName"

Set cboCode = Me![cboCombo0]

'If Your Data Type is a String
For intCounter = 0 To cboCode.ListCount - 1
DoCmd.OpenReport stDocName, acViewPreview, , "[Field name for Report grouping] = '" & cboCode.ItemData(intCounter) & "'"
DoEvents
blRet = ConvertReportToPDF(stDocName, vbNullString, _
"D:Temp" & GroupVar & ".pdf", False, True, 150, "", "", 0, 0, 0)
'The variable "GroupVar" has beeen declared globally and is initialised at the "OnFormat" event of report generation
'It's then passed to the file name here and cleared just before the end of each loop
GroupVar = ""
DoCmd.Close acReport, stDocName
Next

MsgBox "Your files have been saved to D:temp with individual category names", vbOKOnly

End Sub


There’s no error control and it’s hacked to bits but it works. I hope somebody else can use it.

Cheers
Stephan




I have a report that has a printing anomaly. The report groups on matching field numbers (left hand column) like this:

10000 10 11
10000 20 21
_____________________________
Total 30 32________________

20000 4 6
20000 5 9
_____________________________
Total 9 15________________

30000 8 7
30000 9 6
___________________________
Total 17 13________________


Underneath each grouping, as in the above illustration, there is a footer that sums the data for each grouping (the two right hand columns). In the footer are two horizontal lines, just as in the above illustration. These lines were inserted using Tools/Line. When I run the report, I see these horizontal lines onscreen and they look exactly like I want them to. But when I print the report, not all the horizontal lines show. Sometimes the top one is missing, sometimes the bottom, sometimes both.

I cannot comprehend this since these lines all generate from the same footer and can be seen onscreen. I also tried another printer; same result.

Ideas?

Thx, William




For use with Access 2007, I need a form to open a report that groups on ‘Brokers’ and displays ‘Deposits’ for each group based on a ‘StartDate’ and ‘EndDate’ the user enters on the form and picks the ‘Preview Report’ button that executes some VBA code on-click.

Currently, the code provided by Allen Browne works ok, when the date fields are empty. That report shows all of the brokers grouped by ‘brokers’ and all deposits for all records, including sub-totals for each of the brokers. That is ok for a summary report. However, when one or both date fields contain a date(s), the report only shows the headers.

I have records for multiple years that the query gathers from a table called ‘tblInvoices”, but I only want the report to group the ‘Brokers’ and show the ‘Deposits’ for each broker between the dates entered and (later), eventually, for a ‘broker’ that I select from a combo box on the same form.

I did try solving this on my own, which is how you learn how to use the program, but am running up against a dead-line and am seeking assistance from you wizards lurking in the background. Thanks in advance for your most appreciated assistance. Punice




I hope I don't get in trouble for starting a new thread, but I can not find anything on the forum that has helped me with my little dilemma. I have a pretty nice report designed and I would like to add a Group Header (Access 2010). It's a basic report of a Name and Address File which is already sorted on State and Zip Code (all in one field-I didn't design the original database). The user wants one report with this sort and I need to put a Group Header on the report; just the first letter of the state. I would like a little kind of break after the end of each group as long as the Group Header is not left on the end of a Page without any data Of course, I can't figure it out. Now, just to be clear, he is going to want reports sorted/grouped a million different ways from Sunday, so whatever I can learn here will certainly go a long way. I will be very grateful to anyone who can help me in enough detail that I can execute. I am very dumb and need pretty detailed instructions. I have some instructions on another subject that I got on line and there is a 'copy and paste' action and no where any where can you see where to paste or do the instructions tell you where to paste; so, on that issue I'm hanging in the wind.
Thanking you in advance for any info you will provide.




Can someone please help review this code. I have been working on this for months now and at a loss. Have a multi list box/combo box form that should open a form on preview command. I have run into multiple issues which I had in other topics. After reviewing help files and chnaging code, form and reports I am still getting errors. Its time to move on our quit. Please help.

Currently I am getting Run Time Type Mismatch 13. on this line
If IsNull(TempVars![Display1]) Or (TempVars![Display]) Or IsNull(TempVars![Year]) Or IsNull(TempVars![Month]) Then

Report

	Code:
	Private Sub Report_Open(Cancel As Integer)
    On Error GoTo ErrorHandler
    Dim strSQL As String
    If IsNull(TempVars![Display1]) Or (TempVars![Display]) Or IsNull(TempVars![Year]) Or IsNull(TempVars![Month]) Then
        DoCmd.OpenForm "Sales Reports Dialog2"
        Cancel = True
        Exit Sub
    End If
    
    strSQL = "SELECT [Year]"
    strSQL = strSQL & ", First([" & TempVars![Display1] & "],) AS SalesGroupingField1"
    strSQL = strSQL & ", First([" & TempVars![Display] & "],) AS SalesGroupingField"
    strSQL = strSQL & ", Sum([Sales]) AS [Total Sales]"
    strSQL = strSQL & ", Sum([Commission]) AS [Total Commission]"
    strSQL = strSQL & ", Sum([Employee]) AS [Total Employee]"
    strSQL = strSQL & ", First([Sales Analysis].[Month Name]) AS [Month Name]"
    strSQL = strSQL & " FROM [Sales Analysis] "
    strSQL = strSQL & " Where [Year]=" & TempVars![Year]
    strSQL = strSQL & " GROUP BY [Year], [" & TempVars![Group By1] & "], [" & TempVars![Group By] & "]"
    
    
     Debug.Print strSQL
    Me.RecordSource = strSQL
    Me.SalesGroupingField1_Label.Caption = TempVars![Display1]
    Me.SalesGroupingField_Label.Caption = TempVars![Display]
Done:
    Exit Sub
ErrorHandler:
    ' Resume statement will be hit when debugging
    If eh.LogError("Yearly Sales Report1_Open", "strSQL = " & strSQL) Then
        Resume
    Else
        Cancel = True
    End If
End Sub

Form Code

	Code:
	Sub PrintReports(ReportView As AcView)
    ' This procedure used in Preview_Click and Print_Click Sub procedures.
    ' Preview or print report selected in the ReportToPrint option group.
    ' Then close the Print Sales Reports Dialog form.
    Dim strReportName As String
    Dim strGroupingFilter As String
    Dim strReportFilter As String
    Dim lOrderCount As Long
    ' Determine report filtering
    If Nz(Me.lstReportFilter)  "" Then
        strReportFilter = "([SalesGroupingField] = """ & Me.lstReportFilter & """)"
    End If
    
    ' Determine reporting time frame
    Select Case Me.lstSalesPeriod1
    Case ByYear
        strReportName = "Yearly Sales Report1"
        lOrderCount = DCountWrapper("*", "Sales Analysis", "[Year]=" & Me.cbYear)
    Case ByQuarter
        strReportName = "Quarterly Sales Report"
        lOrderCount = DCountWrapper("*", "Sales Analysis", "[Year]=" & Me.cbYear & " AND [Quarter]=" & Me.cbQuarter)
    Case ByMonth
        strReportName = "Yearly Sales Report1"
        lOrderCount = DCountWrapper("*", "Sales Analysis", "[Year]=" & Me.cbYear & " AND [Month]=" & Me.cbMonth)
    End Select
        
    If lOrderCount > 0 Then
        TempVars.Add "Group By1", Me.lstSalesGrouping.Value
        TempVars.Add "Group By", Me.lstSalesReports.Value
        TempVars.Add "Order By", Me.lstSalesReports.Value
        TempVars.Add "Display1", DLookupStringWrapper("[Display]", "Sales Reports2", "[Group By]='" & Nz(Me.lstSalesGrouping)
& "'")
        TempVars.Add "Display", DLookupStringWrapper("[Display]", "Sales Reports", "[Group By]='" & Nz(Me.lstSalesReports) &
"'")
        TempVars.Add "Year", Me.cbYear.Value
        TempVars.Add "Quarter", Me.cbQuarter.Value
        TempVars.Add "Month", Me.cbMonth.Value
   
        eh.TryToCloseObject
        DoCmd.OpenReport strReportName, ReportView, , strReportFilter, acWindowNormal
    Else
        MsgBoxOKOnly NoSalesInPeriod
    End If
    
End Sub

Pointers? Help? Direction?
It really should not be this hard, maybe I am overthinking or underthinking.......I am at a loss.




I have a lot MS Access 2003 reports that has multiple groupings on the report that I need to export to Excel. When I exported the report to Excel everything was out of whack because of the group headers and footers. I tried exporting the report to HTML and all of the columns including the groups lined up perfectly! I could even open the html document using excel and everything was perfect. Opening the html document with Excel would work except for the fact that Access puts the report out into multiple html documents.
I need the data to be output exactly as it is on the reports with all of the groupings and totals for each group so outputting a table or query wouldn't work because it wouldn't have any of the subtotals I need. Outputting the data to XML also wouldn’t work because I wouldn’t be able to automatically open it Excel for my boss.

My supervisor wants the data with the sub totals so he can do who knows what. The reports are quite large some containing a thousand rows or more.
I know quite a bit of VBA so I could automate the process of outputting the data to an html document and then simply stuffing the data into an html document and then opening it with Excel.

Does anyone know how to force MS Access to stuff everything into one html document instead of multiple documents when exporting table, forms or reports to HTML?.




Hello all,

I'm struggling to come up with a recordsource for a report in the following circumstances:

Employees work on Shifts, each shift has multiple deliveries, each delivery is to a certain district.

What I need is a report grouped by district, showing the employees who have NOT made a delivery to that district.
This would be something along the lines of:

District A
Employee 3
Employee 5

District B
Employee 2
Employee 9

and so on.

I can get the recordsource correct to show which employees HAVE made deliveries to each district.

And I can come up with a recordsource that shows me who has not made any deliveries to any district (or I can limit it to a particular district by adding that to the WHERE statement)

	Code:
	SELECT lngEmployeeID, strFullName FROM tblEmployees e
WHERE NOT EXISTS (SELECT * FROM  tblShifts s 
INNER JOIN tblDeliveries d ON s.lngShiftID = d.lngShiftID 
WHERE e.lngEmployeeID = s.lngDriver OR e.lngEmployeeID = s.lngLoader

But I can't figure out what recordsource I would need to be able to produce the report described above.

If anybody can offer any suggestions or help that would be very much appreciated (even if the help is stating that it can't be done!)




Hey
Im getting really frustrated and hope you can help.

I want to produce a report which calculates the total for how much the customer will be charged for work by multiple labourers, and i want to calculate how much the customer will be charged for multiple items that are to be used on the job.

I have created a query that will calculate the tax, and the total and the subtotal, but I havent a clue how to calculate multiple "ItemCosts" (each having the invoice number as the relationship) and multiple "LabourCosts" (again each having the invoice number as the relationship).

To give you an idea of the relations in the database, below I will attach the database.

Please see the "Invoice" query.

Thanks Attached Files DatabaseZip.zip (803.6 KB, 7 views) Reply With Quote 05-07-2010, 05:29 AM #2 Datagopherdan Competent Performer Windows 7 Access 2007 Join Date Dec 2008 Posts 220 I didn't open your database but from what you're saying, you should just be able to do group level headers and footers in your report to give you figures for each customer. You would create a customer header and footer and in the detail section you would have all those line items with a calculated field of the totals in the footer section.

If you do a google search on Access Report Groupings, you'll find alot of exampled on how to do it.




I am not sure if this question belongs here or in the queries section, but since my problem is with the report, here it is:

I have 2 queries. The first one is basically my source where i perform a simple running sum using a SQL Select code. The second query is there so i can filter out unwanted transactions and keep the running sum totals i calculated in the first query intact and working correctly.

My problem comes in with the report.

I create the report and format it, no problems. The issue comes in where i want to use groupings - to filter the transactions per year. I can create the grouping alright (using the grouping function in Access 2010), but what the report does is to take the last result in the running total that my first query calculated and makes all the previous result that the SQL query calculated identical. (i have checked the query whilst the report is open and it is correct)

So assume in a 3 line report, the running sum cell was
6
12
18

the running sum column for all 3 lines is 18 when i turn the groupings on.

When i turn the grouping off, the report then shows the correct results again.

Any insight into this issue would be greatly appreciated.




Hello,

I have a report that includes a sub-report. The main report shows a list of transactions made in a quarter and it is grouped by Department. Sometimes a transaction is part of a group that includes many related transactions under the same group ID. However, it is possible that one or many transactions within that group were assigned to a different Department.

The sub-report serves the purpose of listing all of the transactions that are part of a group within a Department and it is embedded bellow the main report regular Department heading. What I am trying to accomplish is to also include in the sub-report the Department name associated to each of the different transactions that are part of the group shown in the sub-report. That part was easy and I have done that. However here it is my challenge.

Most of the time this field will have the same value as the main department heading of the main report, however, as mentioned earlier, there will be times that one of these transactions was linked to another Department. It is then when I would like to only show the field name for that department so it will stand out easily, rather than to bury it with all of the other field names.

In other words, I would like for the department field to appear on the sub-report only if its value is different (does not equal) from the main department heading value of the main report group heading in which the sub-report is embedded.

I tried using conditional formatting to make the field color same as background if met the condition but that option doesn't work 100% for me because my report is banded (to improve readability due to the many lines) and it works well on the White bands/rows but on the Grey bands/rows it shows the hidden font which I have set its color to white. Unless there is a way to overcome this I will need help in creating a VBA code to make the matching text invisible.

Thanks in advance for your time and effort in helping me.

Regards,




I have a lot MS Access 2003 reports that has multiple groupings on the report that I need to export to Excel. When I exported the report to Excel everything was out of whack because of the group headers and footers. I tried exporting the report to HTML and all of the columns including the groups lined up perfectly! I could even open the html document using excel and everything was perfect. Opening the html document with Excel would work except for the fact that Access puts the report out into multiple html documents.
I need the data to be output exactly as it is on the reports with all of the groupings and totals for each group so outputting a table or query wouldn't work because it wouldn't have any of the subtotals I need. Outputting the data to XML also wouldn’t work because I wouldn’t be able to automatically open it Excel for my boss.

My supervisor wants the data with the sub totals so he can do who knows what. The reports are quite large some containing a thousand rows or more.
I know quite a bit of VBA so I could automate the process of outputting the data to an html document and then simply stuffing the data into an html document and then opening it with Excel.

Does anyone know how to force MS Access to stuff everything into one html document instead of multiple documents when exporting table, forms or reports to HTML?.




I have 3 Departments that need to maintain their own data for a report I generate.

I will create each dept a table in their own database to so I can link to their table data via a KEY: PRODUCT ID

My origional report has 1 table for the actual specs. I request your help in devising a query -> report for 3 additional tables for min, target, max data to combine in 1 report.

Right now my test query output is in the form of (on the same line)

PRODUCT ID / Dept 1, Spec Parameter 1, Min 1, Target 1, Max 1, Dept 2, Spec Parameter 2, Min 2, Target 2, Max 2, Dept 3, Spec Parameter 3, Min 3, Target 3, Max 3,....

I have a field named: ORDER to get spec parameter in perferred place on the report.

I would like report output to look something like:
PRODUCT ID
Dept 1, Spec Parameter 1, Min 1, Target 1, Max 1,
" "
" "
Dept 2, Spec Parameter 2, Min 2, Target 2, Max 2
" "
" "
Dept 3, Spec Parameter 3, Min 3, Target 3, Max 3,....
" "
" "

Query Problem?
Report Group / Sort Problem?

I trigger the print sequence when I scan a barcode.

Thanks for your time and suggestions.




I'm not quite sure how to go about creating the kind of report I need. I have 3 tables, I'll call them "Categories", "Sub-Categories", and "Line Items". I want to print a report that shows on the first pages each "Sub-Category" grouped by "Category". Then I would like to have each "Line Item" printed grouped by "Category:Sub-Categroy"

This seems to be a 2-part report. Can this be accomplished by the report wizard. I haven't been able to figure it out.

Thanks,
esurfer




I already constructed the report. However, my boss now has asked that I include subtotals and line counts by section and a grand total at the bottom.

Also, wanting to force page break only in cases where the natural break would come in the middle of a grouping.

Thanks.




I had a problem with lines that I drew in a report, they wouldn't grow or shrink depending on if there was data or not. Then someone (probably from this group) directed me to microsoft's page where they have a database with a bunch of solutions to different problems (the address escapes me now).

Now, onto my problem. I am trying to do this, draw a dynamic line up and down my report. I have tried the following three methods, but I keep getting the same result, a line going from the top to below the bottom of where the lowest control is

	Code:
	'bottomLine being the bottom most line on the page
Me.Line (0 * 1440, 0)-(0 * 1440, Me.bottomLine.top)
Me.Line (2 * 1440, 0)-(2 * 1440, Me.ScaleHeight)
Me.Line (4.4167 * 1440, 0)-(4.4167 * 1440, 14400)
Me.Line (6.5 * 1440, 0)-(6.5 * 1440, 10 * 1440)

I have also tried putting a tiny line in, and then lengthening it by code:

	Code:
	Me.vertLine0.Height = bottomLine.Top
Me.vertLine1.Height = Me.ScaleHeight
Me.vertLine2.Height = 14400
Me.vertLine3.Height = 14400

but when I try this, any feilds that I have made invisible, their space is still retained, which leaves a big space in the middle of my report. (In essence, these lines take on the Top of bottomLine frlom the design view, not run time, as well as the scale height)
(14400 was the number they gave me, as being a really big number)

Thank you in advance for any help.


Page 1 of 20.
Results 1...20 of 391