| Thread | Last Post | Replies |
|
| records total expressions not working | 31 Jul 2007 17:14 GMT | 3 |
I have a report wherein I would like to total the number of meeting registrants. I enter the following expressions in a text box in the report's footer and neither of them work. =sum([LastName])
|
| Conditional format | 31 Jul 2007 16:04 GMT | 4 |
I have a report with a conditional format that works fine on the "left" page but I created a report with the same format (the right page) and it won't work. It is a simple line count from a hidden field called "rulenumber"
|
| Need to keep field groups together | 31 Jul 2007 15:08 GMT | 3 |
Here's is the format to my report: Sec. Item# Description UPC _____________________________________ ### #### ######## #########
|
| Group Together | 31 Jul 2007 13:54 GMT | 3 |
I have a report containing 2 sub-reports. One is to show a list of book IDs that are checked out today, and the other one is a list of book IDs that are checked in today. Currently, the book ID text box is in the Book ID Header section. The report does list a listing book IDs ...
|
| Are these calculations possible? | 31 Jul 2007 13:21 GMT | 1 |
I have a report made up of multiple investment funds. I have totaled the amount for each individual fund in the group footer which is the way the client wants it. The clincher is they want the total from one of the funds to show that it is subracted and then added to a ...
|
| Coding problems with User defined Visible Property | 31 Jul 2007 12:41 GMT | 2 |
I have a report that my users supply to seavel groups. Some do not require certain fields so these will be hidden by using a checkbox on the relevant form. At the moment, I am using the following in code builder: Me.txt[recordNumber].Visible = ...
|
| report problems | 31 Jul 2007 12:38 GMT | 1 |
i have a check box whose control source is: =[Total In Stock]-[reorderlevel]<=0 how can i set the control to only be visible if this check box is true?
|
| Rounded Rectangle | 31 Jul 2007 10:16 GMT | 2 |
I need to insert rounded rectangles on an access report. To see what I mean, open Paint, and selected rounded rectangles from the toolbox. These rectangles are to be in the report header, footer, and body. For the header and footer, I just drew the rectangle in paint, then pasted
|
| Query that feeds the report | 31 Jul 2007 05:50 GMT | 3 |
Im using Windows XP and Office 2003 I would like to put more than 255 fields in my report. I have one query that feeds my report. That query is full [255 fields]. If i take the query that is full and and make a relationship between it and
|
| Print Preview Window Handling | 31 Jul 2007 05:29 GMT | 2 |
I open a report from VBA code in a form. I use acViewPreview and open it as a dialog (window type is acDialog). In the report's OnOpen event, I maximize. The reason I want that is because I want a full screen preview, and I don't
|
| In Access what expression do I use to average a field ignoring 0? | 31 Jul 2007 01:13 GMT | 2 |
I have a report that calculates the average of a requested field. The average is not correct due to "0" values in some of the records. What expression do I use in the Control Source to ignore the 0 entries? I tried to adapt the one I use in Excel but did not get the results I was ...
|
| Problem with If.... Then.... Else.... Statement | 30 Jul 2007 23:16 GMT | 7 |
Trying to run a report which will look at a field and if a persons name appears in that field the their signature will be visible on the report, if it is not there name then another person signature will appear. I have put the if statement below on the reports Details section in ...
|
| Format a report | 30 Jul 2007 22:01 GMT | 1 |
I have a table with a single field named "ID". I would like to print a five column report which would display my first 5 ID's across the page and then display the next 5 ID's on the next line and so on. Can I do that? Thanks for any suggestions you may have.
|
| Calculating Averages | 30 Jul 2007 21:22 GMT | 10 |
I am trying to calculate an average on the following [score A]+[score B]+[score C]+[score D] These are text fields with validation rule ="NA" or Between 1 and 5
|
| Counting records by financial year | 30 Jul 2007 20:54 GMT | 1 |
I am trying to count the number of jobs in a program, based on the financial year. I have found I can set the properties so that it starts a new year on each page, but I cannot get it to change to financial year. I then need to count the records in the separate programs in each ...
|