| Thread | Last Post | Replies |
|
| need # days between received and signed collumns w/o weekends | 19 Jun 2007 19:47 GMT | 1 |
In my access database report I have a received collumn and a signed collumn, and need # days between received and signed collumns with out counting weekends. Can you explain how to add a field to my report to calculate how many week days it took to sign the document?
|
| On close, report goes to DESIGN view | 19 Jun 2007 19:47 GMT | 2 |
Using Office 2003 and Windows XP; I have a custom toolbar for reports to control the app during print preview mode. The program copies the "Close" button from the normal toolbar so the user can close the report.
|
| Can't find report design, yet DoCmd.OpenReport can | 19 Jun 2007 19:34 GMT | 2 |
I have a report built by a previous developer. When the button that provides the parameters and displays the report is pressed, it appears for preview and printing. If I switch it to design mode, I can make changes to the layout that show up the next time I run the report. But I ...
|
| $0.00 in calculated field in report | 19 Jun 2007 17:56 GMT | 7 |
I am a very novice 2000 Acess user. Please Help!. I have an invoice with many calculated fields. Everything works great when I work in a table of form view. I am have trouble doing a report. I am only bring over 2 calculated field to my report (sub total and amoun due) and ...
|
| Help With Page 2 #2 | 19 Jun 2007 16:26 GMT | 9 |
I have a number of similar databases all with reports which are used to print cheques. In some databases, page 2 of the report prints too high although pages 1 and 3 through to the end print correctly. In other databases, all pages print correctly.
|
| DATE ON REPORT | 19 Jun 2007 13:56 GMT | 2 |
I have a form that allows a user to input the date range they are wanting for a report. I want this date to print on the report, which I got to do, in print preview. But when I go to print the report it prints #NAME. This is what I put on the report in a text box ...
|
| Summary Page | 19 Jun 2007 13:44 GMT | 2 |
I need an overview page at the front of a report! I can do the overview report separately but is there anyway to insert it at the beginning of the main report. Situation is complicated a bit, I think, because the main report uses
|
| Sorting by control with an aggregate expression | 19 Jun 2007 12:53 GMT | 9 |
C.I need to generate a report that sorts on the results of the expression within the detail section that performs a calculation based on an expression. I need to rank the results in descending order. I can't figure out how to do this type of sort in one step. Is it possible?
|
| Print record once, update Yes/No field verifiying print | 19 Jun 2007 04:24 GMT | 2 |
I would like to print a group of records, then have a Yes/No field [Printed] updated in my Jobs table with an update query showing the records were printed. Then next time the report runs, In my query criteria I will test for True values on the Yes/No field. Then only the ...
|
| reports with linked picture | 19 Jun 2007 04:05 GMT | 2 |
Why does my Access report with a linked picture print first the picture and then a second page with the picture and the report fields data?
|
| Filtered Report returns no values | 19 Jun 2007 03:21 GMT | 2 |
I use a certain form to make a report. In this form there’s a ComboBox where users can choose a value in order to make a filtered report. After the user picks a value, he clicks on a OK button and the filtered report appears on the screen. The problem I’m facing is that when the ...
|
| Sorting/Ranking Aggregate Expression in Control Source??? | 18 Jun 2007 22:58 GMT | 4 |
I would like to sort the results of the following expression in control sources located in the detail footer in order to rank the results. =Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151]) Is it possible?
|
| Sorting Aggregate Control | 18 Jun 2007 22:57 GMT | 1 |
=Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151])
|
| Test for a null date | 18 Jun 2007 22:37 GMT | 3 |
I am getting an #error display on the following function in a control on a report =IIf(IsNull([Projected Start Date]),"",[Projected Start Date]) Why?
|
| How to add field to report from the bound table? | 18 Jun 2007 20:06 GMT | 1 |
Hi, All I have report (data source is table) when i built report i selected specific fields as usual,now i need to update report and add one field which is in a bound table, but it wasn't selected initially,
|