| Thread | Last Post | Replies |
|
| Printing a table type report | 22 Apr 2008 21:06 GMT | 3 |
I have a report that is mostly a table. I've added horizontal and vertical lines to give it a table appearance. The first thing I noticed is the table did not start printing on page 1, it started on page 2. The next thing I notice is that my labels, thay contain
|
| Sorting Dates | 22 Apr 2008 20:08 GMT | 14 |
I have looked through all the postings, but don't see one that quite fits what I am doing, and have failed at all the attempts I have made. I am sorting Seniority Dates in a total overtime report. When 3 employees have the same year to date total hours of overtime, I need it ...
|
| Dynamic report formatting | 22 Apr 2008 18:49 GMT | 1 |
In some forms I have a group of combo boxes that may have a Yes or No answer. Associated with that combo box is two or three text boxes. I've programmed the forms such that if the user enters Yes then the background color of the associated text box is changed. That works fine.
|
| ForceNewPage | 22 Apr 2008 18:36 GMT | 1 |
Why, when setting ForceNewPage = 2 in a footer section, I always get a blank page in the end of the report. Why Access 2003 and 2007 (where I have tested this) doesn’t suppress this last page automatically.
|
| Reporting on a value range | 22 Apr 2008 16:49 GMT | 3 |
I have a reporting page with various unbound combo boxes. I have successfully used two of these to populate criteria for a date range. Ideally, I would like to add two more boxes to allow the user to input minimum and maximum production ranges in addition to the dates, but I cannot
|
| DSum Problem | 22 Apr 2008 16:42 GMT | 1 |
I have a report that I have AmountDue1, AmountDue2, and AmountDue3. At the bottome of the report, I want to add all the Amounts together. I did a DSum function: =DSum("AmountDue1","[QueryName]"), but that only gets AmountDue1.
|
| supressing zeros in calculated fields | 22 Apr 2008 16:35 GMT | 3 |
I'm an acess hack, trying to finish a project. I know just enough to get myself in trouble!! Making a report, which extends pricing (quantity * price = extended price) the extended price is a calculated field, and that works fine. I can even
|
| Running multiple reports | 22 Apr 2008 13:33 GMT | 2 |
I have 3 reports that are each bound to a different query. I want to run all three each week by clicking a button (needs to be simple in case I'm not here!) How do I do it? Ideally I want the button on the switch form but just think it'd be easier to have one button than 3 ...
|
| rpt footer appearing in middle of report | 22 Apr 2008 12:23 GMT | 1 |
I'm not sure what is wrong, I'm running a report and now for some odd reason the footer is appearing in the various places in the report, just not at the bottom where it is supposed to. Any idea what would cause this. thanks for your help,\.
|
| Sub query - select according to main query | 22 Apr 2008 09:36 GMT | 2 |
I have done a report with main and sub query. My main query should just select one doctor. This is done on a form with a drop down menu. The doctor's name on the main form seem to update with my selection but the information in the sub query.
|
| Problem with Sum Function | 22 Apr 2008 03:58 GMT | 5 |
Am trying to figure out a way to sum the values in four columns, basically A, B, C, D. Each column is represented as TextA, TextB, TextC, and TextD. I thought I could do something like this: =[TextA]+[TextB]+[TextC]+[TextD] That method actually works fine, but only is all four ...
|
| Blank page if sub report has no data | 21 Apr 2008 23:42 GMT | 1 |
I have a report with 3 sub reports. When one of the sub reports has no data it creates a blank page. I have the margins formatted corectly. It only creates a blank if the sub report has no data.
|
| unbound control | 21 Apr 2008 23:15 GMT | 1 |
I have an unbound control on a report which I'd like to fill on load. An "If" statement controls the input according to a couple of conditions. Problem is, I get an error that the control is read-only and I can't edit my control. Is this normal for reports? Can I not fill an ...
|
| bold item in sub report | 21 Apr 2008 21:58 GMT | 3 |
I have a report with a sub report which list dates for a given item. Basically the user can enter a multide of dates for the item and they get listed in the sub report. I am needing to make the date appear in bold if the date is in the next 7 day windows and this only for the ...
|
| Omit detail if no data | 21 Apr 2008 21:30 GMT | 4 |
I have a report that is created from two tables. One table has names and the other table has activity for the names in the names table. One (names) to many (activity) relation. My report contains the names and under each name is the activity (detail section) for that person. ...
|