Snaking Report with Fixed Columns

I need a report with anywhere from 3 to 5 columns across. I want the column headings (evenly spaced) to print with existing data (dates all coming from one field) first and then a bunch of blanks below for the length of the page, like so: TERR1 TERR2 TERR3 TERR4 __________| __________| __________| __________| __________| __________| __________| __________| __________| __________| __________| __________| __________| __________| __________| __________| __________| __________|

Passing values between reports

Here is the deal, I have a billing system that uses multiple reports. All reports get open when I run the system. Everything works fine when there is data in all the reports, and data summaries gets passed from all reports to the summary report. Sometimes in one or more reports in a certain month, there is no data, and instead of passing 0 (zero) from the these reports that do not have data to the summary reports. I get #Error or #Name. (The summary values to be passed are usually in the footer section of the reports) I use this on the summary report to get the values from the re

Average in a Sub Report Not Working

I have created a report that has 2 sub reports in it. The report consists of call handling data for 6 agents. One of the subreports contains a field that averages the data among the 6 agents. When I run the sub report on its own, the average field works fine. When I run the main report the average field only uses the one agent. So if Jane Doe's data was 94%, then her "team average" is also 94%. When I go to the next agent, John Smith's data was 87%, and the "team average" listed there is also 87%. It should list the average of all (e.g. 94+87/2=90.5%). Thanks for any help!

Displaying info from multiple records in a report

I have a query that, as an example, returns records containing Employee Name, Employee #, Employee Team, & Employee Address. My report displays up to three records per page, one under the next. The number of records per page depends on the Employee Team field which can be the same for multiple employees One, how do I display multiple records per page and two, how do I do that based on Employee Team? Kinda new to Access and any help is appreciated.

11x17 Print

The Printer being used DOES have a Driver that supports 11x17. In the Report "File - Page Setup", 11x17 IS available, but the Setting doesn't always work on some Reports. I've tried Setting the 11x17 in Report Preview, and in Report Design...neither works. Any TIPs? TIA - Bob

Get fiscal year to show in a report

I have a database that I'm trying to get a report to sort on my fiscal year. I have a module that I set up (below) to set the dates for my fiscal year. Function FiscalYear() As Date Dim dtFiscalYear As Date Dim strFiscalYear As String Dim intMonth As Integer intMonth = Month(Date) 'this will tell you the current month If intMonth < 11 Then strFiscalYear = "11/1/" & Year(Date) - 1 Else strFiscalYear = "11/1/" & Year(Date) End If dtFiscalYear = CDate(strFiscalYear) FiscalYear = dtFiscalYear End Function I then add

Custom Grouping

I have a table with dates and expenses. Billing cycle starts on on the 24th of each month, and I need to divide the month into four parts (approx). I want there to be a header for the week starting date, followed by seven days. Therefore, the week may start on Wed, 24-Feb and end on Tues, 3-Mar. For example, I want the report to appear like: Week Starting Date Expense 24-Feb 24-Feb $10 25-Feb $15 26-Feb

Printing Question

I have a report that I have been doing in Excel but is better done in Access. However, the report is too large to print on a single page and that is a necessity. With Excel, I just adjusted the scaling. I can't seem to do that with Access I've also tried exporting from Access to Excel, but the calculated fields are not exported. Any suggestions on how I can print the report on one page?

Where do I initialize variables in a report?

Hi, Where do I initialize public variables in a report? I have a public variable where I put a sequential item number on each print line. In the On Open event, I initilalized this ublic variables to 0. I then do a print preview and a print. The print preview works fine, but the print picks up the count from where the print preview left off. I moved my initialization the the Report Header On Print event and it works fine. Is this the right way to initialize this variable or is there a more appropriate event to initialize my variable. I tried On Activate, but that di

Assemby Report

I have a report I need to create in Access 2003. The design has products that are made up of sub products (which can have sub products), how can I show the sub products by displaying them to the right of their parent products, almost like a tree view control on a form?

Cancel = True - error

Hello All I have a number of reports where I have set the OnNoData event to Cancel = True. This works fine where the user attempts to open one of the report usign a button created with the wizard for that purpose, but if they click a button where the OnClick event includes lots of DoCmd OpenReport commands, when the code reaches a report with no data they get a message that the OpenReport was cancelled - and the code stops. What do I do? Hope someone can help Many thanks Leslie Isaacs

Report header below page header

I want a report heading on the first page - but I would like it to be below the page header (so that my page header is identically positioned on all pages). Alternatively I want a part of my page header only displayed on the first page. How can this be made? -- Diane

View/Print Individual Reports

Here is what I have: I have a database for tracking therapy clients. Client data is in one table. Therapy progress notes are in another with a one-to-many relationship. I have a form w/ subform set up to receive the data. I have a query set up to tie the two tables together and feed into a report. (Tables/Forms and Queries all do what I want them to properly) Right now, the report contains data from every client and progress note. What I want is to be able to place a button on the subform for the progress notes, so that when it is clicked it generates the report with just that

Group Header

I have a text box named "txtCount" and the control source it is counting tranches for each customer. I want this report to look at the highest number of tranches for each customer. So ABC company has the highest number of tranches I want that many rows for each customer. Can this be done? I was thinking in the On Format of the group header.

Running Total in report using net of two columns in third column

I have a client time/fees database of over 22k records. I have a report which provided a summary of all time booke and all fees charges to that client. What I require is two additional columns the first which provides a running total of time bookings and the second which provides a running total of the net of the time booked field less the fees charged field, i.e. the net of time bookings which have not been invoiced. I can do this in excel but in access I appear to be getting data from other clients which should not be included in the report.

How to prevent totals from doubling in printed report

I accumulate some totals in the Detail format event. WHen I vies the report, these totals are correct, but when I print the report, they are doubled. I now know when printing, Access processes the report twice. Since all of my reports must be able to be viewed as well as printed, how can I use VBA code to skip the accumulation on either the first or the second pass? Also, how can I determine if the report is being Viewed or Printed? Thanks,

Merging results from multi-selection fields

I've created a database with several fields containing multiple selections. I'm hoping to display the results in 1 grouped field. Is this even possible? I am an Access novice.

Linking from a report to a form for same record

How can you make a report that allows you to have a link or button for each record that displays which you can click and it will open a form for that specific record? This maybe easy, but I am still new to access. I appreciate any support that can be provided.

MS e-learning 5456ae lab

I am on the "Manually01" lab. Number 4 says to "expand the Categories field list, in the Field List pane, click the plus sign". Where is this Field List pane? I can't find it.

Code to read email from Outlook

Anyone have code to read incoming email messages from ONE email address, or experience with the functionality in Access2007 to do this process. I have an upcoming project that will require this and I haven't looked into this area. Example: emails that are sent to support@blah.com are added to a table in the database (everytime the user presses a button or a timer starts a process). The "body" of the email goes into one field and the "from" email address goes into another field. Thanks, Mark

Access Subreport Can Grow Problem

I have an acces reprt with three sub reports and other controls. My problem is that the firs two subreports grow as needed and push everything under them down fine. The third one grows but does not push the controls below it down. All of the properties are identical between the three reports. I cannot figure out why two of them are acting the way i want them to, and on is not. I even created a brand new report and in it are my three subreports with a line after each one. same result. The first two lines get pushed down the third is covered by the subreport. Has anybody had this p

Only ID numbers are printing

I have Access 2007. I have two tables Contact List and Asset List. I am trying to print two reports. I want to print the owner and the companies they lease to from the Asset List. Also from the Contact List I would like to list the Companies and their Lessors. When I try to do the asset list one it only gives me id numbers. What am I doing wrong? -- helpme

need help sorting text by trailing Numbers Value

I am looking for some help sorting a text field (PartNumbers) alphabetically but correctly depending on the value of the ending few charachters if theyre numbers.. Here is some sample data an960pd10 an960pd300 an960pd6 i would like it sorted like this an960pd6 an960pd10 an960pd300 any ideas? Thanks Barry

Display in Report

I have a field named CR, the field size is long integer and the input mask i have as 00\-00000. In this record i enter the case number of a case which is something like 09CR12345, this field currently displays as 09-12345, i want to change this so that in a report it inputs the CR instead of the dash - can someone help.

Calendar Error (Duane's Calendar)

I'm getting a runtime error 13 -- type mismatch and not sure why i'm getting the error. The error is pointing to this line below. The report worked great, but when I start adding more appointments, this error pops up. Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart, Me.ClassTime) * lngOneMinute Dim lngTopMargin As Long Dim lngOneMinute As Long 'size of one minute in twips Dim datSchedStart As Date datSchedStart = #8:00:00 AM# lngOneMinute = 12 lngTopMargin = 1440 'timeline starts 1" down in section Me.MoveLayout = False Me.ClassID.Top

Zoom Size in a Report

All the reports in my database (AC2000) open at 100% in printpreview. the database is split and the backend is on only 1 unit. I have the database on 5 PCs: 3 local and 2 in another state. the local user has 2 desktop units and 1 laptop. the remote user has one of each, both with the frontend resident and the backend on an external hard drive that can be switched as necessary. The problem is that all reports open as 'Fit' on both remove units but as 100% on the local units. I have checked and 'Track name Auto Correct' is NOT checked on any PC. why would this setting

Subtotals

I have a sales order report that I want to display the units ordered subtotal if the ship quantity is zero and/or the line item is open; and the units shipped if the quantity shipped is greater than zero and/or the line item is closed. (if any quantity is shipped that line item is closed). currently I have this for the line item subtotal: SubtotalSO: CCur(tblSOTransactions.UnitPriceSO*[UnitsOrderedSO]) And it displays the units ordered subtotal regardless of whether the line item is open or quanities have been shipped, creating a larger total for the entire report. I'm sure th

Report_Grouping

I have a report with many fields from one table. Six of the fields are memo fields that can grow. I am trying to add a grouping to each of the memo fields so that I can force a new page and / or keep together. The memo fields are not showing on the field/expression dropdown. They are valid fields and are present in the field listing. Do I have too many other fields? Is there a limit? Can you not sort/group on memo fields? I tried having each of the memo fields as a subreport, but that does not work either. Any help you can give me is appreciated. -- Teach me t

double side report print

I have a report to print out on double side print, but it comes flip on the back, any way from MS access to configure the back side printing orientations? Your information is great appreciated,

charts from Data just in two different reports

Basic charting seems to require the information to be in a table. I however have the information only in a report. The two in question are COUNT(*) and the other is week number where the control source =Format$([Dated],"ww",0,0) Could anyone give me a pointer how to graph these please and as I have two similar such reports is it further possible to graph both together on a single chart Many thanks Richard

Group Rows by Subtotal or Count

Have a report that has 97 rows and I want to "Subtotal" the Count of Rows to 30, so I would end up with three "groups" of 30 and one "group" of 7. However, all the group, sort, and totals are by field or names. Once I have them in Groups of 30, I want the Subtotal amount for that group. How do I create this Subtotal Count in the Field Footer of the Report? Thanks.

Master/Child what section

Using Access 2007 As for back as Access 97 I have designed reports with the PageHeader section containing the Master data and the Detail Section containing the Child data. And a PageFooter containing more Master Data. Trying to do a similar report now (Quotes in the PageHeader and Quote Items in the Detail section) think Order and Order Items if you want. Linking fields are QuoteNum in both. Opening this report in report view has ex: QuoteNum 5000 and its data in the PageHeader (as expected) but the Detail Section contains repeating lines of QuoteNum 5000 items. Thirty repeats

saving an access report as a txt file

I have an Access 2000 database file that is being used in access 2003. Everything works fine except when you try to export a report to a txt file the file cuts off lots of data making it useless. I have tried all 4 formats with the same reult. Yet if the same report is exported in Aceess 2000 it works fine. What am I missing or not setting up for? -- the Dataman

ID number showing

I created a report that collects its data from a query. When I run the query the correct information displays. When I run the report one of the fields displays the ID number of the data table rather than the text entered into the table. -- bmorganh

Subheaders

I have a report built to show year one projects, then subcategory of space projects and repair projects. I also have budgets for each project, each category (repair and space), Grand Total, and then an overall running sum. My year one projects id#s start with 1112, year two with 1213. I can't figure out how to get a label for year one and year two. It puts year one and year two on year one projects and year two projects. I have grouped on project year and project category (space or repair.) Thanks!!! -- Milton Purdy ACCESS State of Arkansas

Join problems

Access 2007 I am trying to produce a simple query or at least I think that it should be simple. I apologize in advance as to how I am going to explain but could not think of any other way to express what I am trying to do.. First part of the query returns this qryTestSfActive tblRegStudio.NotActive tblRegModels.NotActive Active PageName StudioID Stage FALSE FALSE TRUE SF Icssa-110 GISILLA FALSE FALSE TRUE SF Icssa-110 Montane FALSE FALSE TRUE SF Icssa-110 Nirvanna FALSE FALSE TRUE SF LATA-010 ALEXEA FALSE FALSE TRUE SF LATA-010 Amanna FALSE FALSE TRUE SF LATA-010 Anyta Paz

Design view arrange

Hello, I am trying to make a custom report in design view, but I want a group of text boxes that have the OnGrow property set to yes, not to affect the bottom one that I have put them far from them. The thing is that in print preview, when the fields grow, I want a few textboxes to stay in place (fixed). Is there a possibility to do that? Thanks!

Printing or Not Printing Pictures

Using Access 2007. This may not be the best approach but this is what I have done... I am trying to create a home inspection database. In my table for bathroom I have the following fields referring to pictures: TPic as an Attachment to add pictures of a toilet (don't laugh!); SPic for sink; VHPic for Venting/Heating; BTPic for bath-tub; SHPic for Shower..... On the form for each area (I have the form set-up as pages / tabs) each attachment field is on the applicable page. That works fine. The user can add as many pictures as they want easily. I can put the attachment fie

Why don't my MS Access Charts Take?

I have created a query, and a blank report. I add a chart, and select the query as data source, using six fields and fill out the rest. BUT, when I go to look at my graph, it DOESN'T pick up the data. I only goes back to showing the 1st Quarter, 2nd Quarter, 3rd Quarter, default data! (and not my own...) Any tips?

User input criteria appearing on report

I have a report that asks the user for beginning and ending dates. How can I get these dates to print on my report? TIA -- Logo

Print Report If Sub-Report Has Data

I have a series of reports that I only need to print if their sub-report has data in it. If there is not sub-report data I don't need to print the report. Pretty standard report based on a query made at the report. Sub-Report based on a table that filters out results specific to that report. -- Thanks As Always Rip

Crosstab Report

Thank you for taking the time to look into this problem. Using Access2007, How can I create a report that looks like this?: ‘ ColumnHead (AuditorID) ‘ Satisfactory Unsatisfactory RowHead1(FloorProgName) RowHead2(FloorProgCriteriaShortDetails) 0 1 RowHead2(FloorProgCriteriaShortDetails) 1 0 RowHead2(FloorProgCriteriaShortDetails) 2 0 RowHead2(FloorProgCriteriaShortDetails)

Need subreport column headers to repeat when data goes onto next p

Hello, I've a subreport that has columns of data. I need the column headers to repeat when the data spills onto the next page so that users will know the type of data they are viewing. How can I do this? Thank you for the help,

Date Difference

Good Morning. I am trying to figure out how to calculate the number of days between two dates. I have a table callled events. That table has event date, event type, event outcome. For example a defendant will have an Advisement Date (AA as stored in the table) and say a Preliminary Hearing date (PH). When i enter information I will enter the date, event type and the event outcome will be (PD for Pending, CN for Continued, or CP for completed). For example Case Number 10-12345 will have an AA on 01/05/10 which is Completed and a Preliminary Hearing on 02/05/10 which was C

Page setup / page / size??????

Hi, When you are in design view and you click on 'Page setup / page / size' are the options listed based on the printer you have installed or are they options that Access knows? If I select any of the options listed will they work on any printer? Thanks, Phil

Duplicate Paramters

I am using Access 2002. I have a report that is grouped by txtCourseTitle and the information is in the group footer. I have another report that I want to show up on this report so I dragged it into the same group footer. Each of these reports has their own parameters to enter for Year and Quarter. When I run the report the first reports parameters run, I enter both of them, then the report that was dragged into the group footers' parameters run. The problem is they run twice. Can anyone tell me why and know how I can fix it to not do that. If the report is run outside of the rep

Underline a portion of Text via VBA

In my report I have a textbox named: Text110 Controlsource ="Svc " & [Svc/Qtn] & " No.: " & [QtnNo] & [QtnAB] The result in the preview is like below : Svc Revised-Estimation No.2010/2356 My requirement is to under line only the portion 2010/2356 only via VBA code. I may have put the line manually under the text, but the description inside the text keep changing some time Estimate, some time Revised-Estimate, therefore the allingment of the line underneath changes. That is the reason for a code, which will draw a line exactly calculating like from Right(Text110,9) Pl

Change Record Source

I'm trying to change the RecordSource of a report based on the value given in a combobox, but it's not working. Any advice to get me pointed in the right direction would be greatly appreciated! Here's the code I have now: Private Sub Report_Open(Cancel As Integer) If Forms!frmReportType!cboReport = "Original" Then Me.RecordSource = qryBilling If Forms!frmReportType!cboReport = "Amended" Then Me.RecordSource = qryBillingAMENDED End If End If End Sub

Using a Calculated Control in a Report

I have a report that uses a query for record source, so in my report procedure I can simply reference the fields by name. However, one important value is from a calculated text box. I need to use this value in selecting records for the report, but I don't know how to reference it from within my procedure. If I had stored it in the table as a field (e.g. tStatus), I could just reference it by name: ' String for Where Conditions, where Status is in a list of selected values. Dim strWhereStatusIn As String strWhereStatusIn = " and tStatus in (" Instead, I have a te

Reports duplicating rows of information

Hi, I have inherited an Access 2000 database. Whilst i am in the process of bringing to a useable standard, it is producing an unusual glitch. I have a form which is used for orders, which the data is subsequently used for producing order forms and invoice sheets. At random times the Report will replicated lines of data from one of the subforms. The data only appears in the table once and I can only see this error on the forms themselves. I am bound to have many other queries as I have become used to using 2007. Thanks in advance Charlotte