Threads Replies Last Post 253 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   How do I sort items in the order I want, not alphabetically. I am doing a report that requires the following five sections to be in this exact order: Claims, Prelitigation, Litigation, Arbitrations, PERBS. How can I keep my data to sort under those Five matters in that order? Access seems to default only to alphabetical or numerical. I want to choose the way I want it sorted, not have it sorted by Arbitration, Claims, Litigation, PERBs, Preli... 1 30.09.2006 20:08:01 lines I need to draw lines on my report in different areas. I have a square frame on my report I need to draw lines on the left side of it or on the right and or on the bottom of it. I need to do it from my data entry form and save it with the recordset. Can that be done? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200609/1 ... 1 30.09.2006 18:07:09 How do I paginate a report in Access? I am trying to create a booklet from an Access Report, and I need to paginate it, but I would like to do this without the use of a different program. Is pagination possible with Access?... 2 30.09.2006 18:05:49 HOW TO TAKE ONLY THE LAST VALUE FOR REPORTS? I HAVE TWO TABLES T1- FIELDS ARE- IDNO AND DATE OF OPERATION T2- IDNO AND FOLLOWUP DATE AND FU TIME IN MONTHS ( FUDATE-DATEOF OPERATION USING DateDiff formula... T1 AND T2 HAVE ONE TO MANY RELATION as the followup continues.. over years.. different values accumulate for the followup period for the same paerson.. for eg one person may be followed for 3 months, other person for 3 y... 2 30.09.2006 17:21:02 How to make Labels report, each label with unique linked image? Note:I know how to make a form with different linked picture for each record... 2 30.09.2006 13:34:58 Timetable Hi, Wonder if someone can help me please. I am relatively new to access, and what I do know is self taught, so I sometimes need a little more guiding than most. I have a form containing data on tests that are carried out e-forms that my department use, so the form that I have set up looks like this: E- Form Description Test 1 Test 2 Form 1 ... 1 30.09.2006 12:18:33 Union Query Report Code???? I have a small business that I run, and I have used Service Time Management wizard to build my database, with some personal changes due to the personal preference and requirements. I am right now stumped at creating a report from a query that sends out notices, ie 1st, 2nd,... for payments. The problem is that I know that there is a way to have a "template" report for all the notices, ju... 8 30.09.2006 05:45:45 Information After Last Group How to add an information only after the last group. The report will be printed in two columns. Thank you. ... 2 30.09.2006 03:36:52 Get value from previous record Hi everyone: I appreciate if someone can help me to figure out a way to solve this problem, it has bothered me for quite a few days now... I have four fields in "MyTable":RecID, CustID,InDate and Comments that document each record ID, customer ID, the date they checked in to the motel and the comment they had regarding their stay. The comment is either "positive" or "negative". What I wa... 3 30.09.2006 02:40:38 Default Sales by Customer MS Access Report I'm using the Default MS Access Sales by Customer reports. Is it possible to have a aging report by 0-30, 31-60, 61-90, 90+ with the total sales format? Can anyone help me with this report. thank you. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200609/1 ... 11 30.09.2006 00:53:55 PDF Background? I need to figure out a way to fill out multiple insurance applications at the same time. I am setting up a form that will accept data, then put it into corresponding fields on an existing PDF. I am basically wanting to make the PDF a background and have the data "laid" on top of it. Is this even possible or am I just crazy?... 2 29.09.2006 22:58:30 DateDiff counting weekdays only I need to calculate the number of weekdays, weekends should not be included, between an[OrderDate] and [ShipDate] in my database report. When I use the "DateDiff" function it returns both weekdays and weekends; i.e. =DateDiff("d",[OrderDate],[ShipDate])... 7 29.09.2006 22:21:04 Setting SourceObject for a subReport I have a Report with series of subReports. I want to change the "SourceObject" of the subReports based upon a value on the main report. On the Report's detail section (where the subReport reside), on the event "Print" I wrote the following code. If Me.TrafficCount > 0 then Reports!ReportName!subReportName.SourceObject = "subReportOne" Else Reports!ReportName!subReportNam... 4 29.09.2006 22:16:03 Report resizing I'm trying to fit more rows of data per page on a report, however resizing it manually in design view does not seem to help me reach my goal. The text keeps getting smaller and smaller, and there's more than enough room to allow for extra rows, yet there's no change. Is there an alternative way of doing this? I'm comparing my report with another similar report that seems like it has bigger ... 3 29.09.2006 21:11:19 Missing names I created a report that's based on a query. The query itself is based on Employees table, Courses Table and a junction table that captures the employee's ids and courses taken. The problem with the report is that when a Last Name is repeated, meaning there's another employee with the same Last Name, albeit a different Employee Id (primary key), the last name only appears once and the co... 4 29.09.2006 21:02:59 ReportToPDF - Access 2003 Currently we output reports to pdf using a different product, and would like to change it because some of the issues we are having. I came across ReportToPDF by lebans.com and would like to try and use this instead. I'm using Access 2003 and some of my reports that I create require a parameter sent to the report via OpenArgs of the docmd.openreport event. Is it possible to send a paramet... 3 29.09.2006 20:43:13 Timetable Hi, I don't even know whether this can be done, but I wonder if someone can help please. I have the following information in an access query: Date Started Date Tested Date Finished Test 14/08/06 30/09/06 31/12/06 Live 01/01/06 31/10/06 31/01/07 I w... 17 29.09.2006 19:33:01 Printing data from another table in report footer I have several reports that print a message in the report footer. The message is the same for all reports. Part of the message needs to change based on certain events. Now I edit each report and change the message text before generating the reports. I would like to put the variable parts in a table and pull from the table to insert into the message. For example the message is "as of VN ... 6 29.09.2006 19:32:27 Cangrow/Canshrink in Lebans RTF control Is there any way to get the Lebans RTF control to perform a cangrow/canshrink in an Access 2003 report? Thx in advance!... 2 29.09.2006 19:13:22 ReportToPDF: pdf attachments? Mr. Lebans, thanks so much for the ReportToPDF tool; it has saved hours upon hours of tedious documenation generation in the last couple weeks! I was hoping to get more information about creating attachments in the output pdf file? A few programs that have been evaluated for doing so don't like the pdf file, due to web optimization or the linearity used to create it. Is it possible to c... 4 29.09.2006 19:12:32 If statement in a report? Using Access 2003 I have a report based on this query below. It shows the names and years worked for employees for the month I type in. I would like to put a control on the report that says "No Anniversarys this month". 2 problems. I don't know if I would add an expression in the query then add a control bound to that field or if there is a way to put the expression in a control on the ... 4 29.09.2006 18:05:55 Access 2003 - calculating age I need to calculate age in a report. I have one table with the following fields "FirstName", "LastName", "Age" and "Birthday". The Age column is blank. I created a report using all the fields in that table. I have tried to use the expressions that others have written in some of the previous postings, but I cannot get them to work. As an example, I tried putting the following as th... 4 29.09.2006 18:03:34 Report that displays number of records in queries Hi there, I have a database I've set up that has a number of queries that filter the data by two (or more) checkboxes. I'd like to set up some kind of summary report that simply indicates how many records are in each of those queries. I feel like this should be simple, but I'm not coming up with any solutions that work... Any suggestions? Thanks! ... 3 29.09.2006 17:52:30 Can you export an Access Report into a Excel spreadsheet Can you take a Access report that is based of several different queries and export it to an Excel spreadsheet?... 2 29.09.2006 17:18:22 Access Report Filter Question When I look at the properties for my report there is a filter and filter on value. How do I add a filter to this report. I am unsure what goes in the filter value. I imagine I enter the name of a filter in this box and put the filter on; but how do I create the filter itself. Is this a function that I must create? I know how to filter using the criteria in the qeury; I would like to be... 2 29.09.2006 16:03:15 253 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>