| Thread | Last Post | Replies |
|
| How do I count selected data in a report footer | 17 Nov 2007 19:36 GMT | 1 |
Am attempting to count the number of conditions in a data field [status] with a certain stated value; in a group summary and then a report summary (i.e. count the Number of records where the data in [status] equals a descriptive value such as “Widow”, “Active”, or “Retired”).
|
| research articles database | 17 Nov 2007 09:12 GMT | 1 |
Hello, I'm not so great with access and am looking for a template for a database that i can keep track of my research articles library. With search strings and various locations for the articles, be they electronic versions, hard copies etc.
|
| Report/Form formatting | 17 Nov 2007 05:32 GMT | 5 |
I asked this question on the formscoding NG but perhaps it's better posted here? Shouldn't this conditional formatting work? (CF applied to a text box on a form.)
|
| Crosstab Query with query parameter used to create a report | 17 Nov 2007 03:31 GMT | 2 |
My crosstab query using a query parameter works fine; however, once I try to use it to create a report I am asked multiple times to re-enter my query parameters. The report generates the correct results; however, why do I need to re-enter
|
| How do I count selected data in a report footer | 17 Nov 2007 03:26 GMT | 1 |
Am attempting to count the number of conditions in a data field with a certain stated value; in a group summary and then a report summary (i.e. count the Number of records where the sum of hours is between 0 and 24).
|
| put group footer into page footer in access report | 17 Nov 2007 00:42 GMT | 1 |
trying to put group footer into page footer in access report as printing on preprinted stock and need to totals in specific boxes ie group footer on last page of group instead of page footer every page.
|
| Access crashes on save/preview | 17 Nov 2007 00:36 GMT | 1 |
I am having a problem with Access. Whenever I am in 'Design Mode' in a Report, Access crashes when I click Save or try to Preview the report. There is not an error message. I have to restart Access. What interesting is that I can go to the Query and it will run fine. Then, I
|
| Report Sorting/Grouping statement too long to edit | 17 Nov 2007 00:23 GMT | 7 |
The too long to edit Statement is: =IIf([Rcd]<=36,(2*[Rcd]+5-((([Rcd]-1) Mod 12))), _ IIf([Rcd]>36,IIf(Int((([Rcd]-((([Rcd]-1) Mod _ 6)+1))/6)/2)= _ (([Rcd]-((([Rcd]-1) Mod 6)+1))/6)/2,(-2*[Rcd]+150)+ _
|
| formatfield | 16 Nov 2007 19:32 GMT | 1 |
I don't understand what is wrong, I'm just trying to merge tow values (adrln1 and adrln2) into a textbox on a report! When I run it I get a message to Enter parameter Value "formatfield" Does anyone see something worng with this code
|
| Report to PDF Font question | 16 Nov 2007 16:42 GMT | 14 |
I am working to implement a very specific design for an Access report that needs to be saved as a pdf file. With Stephen Leban's excellent function I was able to get the report to do so- but with different fonts. The fonts required for the report are in the Helvetica family, ...
|
| Variable # of Column Headings in Crosstab Report | 16 Nov 2007 15:46 GMT | 2 |
I wish to creat a report from a crosstab query based on a table: the query Row Headers are Employees, the column headers are codes relating to actions. I used a wizard to create a report upon this crosstab query and it worked fine until a new code was introduced. Now, the new ...
|
| Query problem | 16 Nov 2007 13:40 GMT | 2 |
Well here I go again. Biting off more than my brain can handle. I have a report that shows all of our machines in our plant. I’m tracking both machine down time (the time the machine is broken) and Plant Down Time (the time the machine is broken that hampers production) I have a ...
|
| Help! Wherecondition date nightmare | 16 Nov 2007 11:02 GMT | 3 |
ok im starting to get the hang of passing queries through the wherecondition instead of queries but this one has me stumped my code Dim stDocName, strdate As String
|
| Report to RTF and Save | 16 Nov 2007 09:54 GMT | 2 |
I have a database that already runs this, unfortunately the person who created has up and retired and I cant ask him. I have created a Report in the Access Database and need to be able to press a button on the Form so it will Run the Report and Save it into a file using
|
| SubReport Problem | 16 Nov 2007 09:24 GMT | 2 |
I have a MainReport, then a SubReport1 which is in the detail section of the main report. The Main and SubReport1 are linked by CoName in the Master and Child Fields. SubReport2 is in the detail section of SubReport1, and they are linked by
|