| Thread | Last Post | Replies |
|
| Only need one record... | 07 Jan 2005 19:30 GMT | 2 |
I'm creating a report for guys to take out to the field with them. I want just one record (with certain information pulled from a query) in the page header section and blank boxes in the detail section. That's all done: the report layout is just the way I want it, but the ...
|
| how to embed image; don't see link option | 07 Jan 2005 19:15 GMT | 1 |
I'm trying to embed (rather than link) a bitmap image into a report. Access help says: "To link to an image, click Link, and then click OK again to complete the process. To embed the image in the table, leave the Link check box blank and click OK. The words "Bitmap Image" ...
|
| Get Access Report Line Count? | 07 Jan 2005 19:01 GMT | 5 |
1. Is there a way to get the total line count of a report, not just the page count? 2. My client wants a report of varying actual length to stay within two printed pages.
|
| How do I get an Access Report copied into an exisiting word docume | 07 Jan 2005 18:35 GMT | 1 |
I have designed an access report just the way I want it, but now I need to have that report copied into a word document. I tried using the publish with word feature, but it loses some of the formatting (lines). How do I get my perfectly formatted access report into an exisiting ...
|
| Password | 07 Jan 2005 18:29 GMT | 2 |
Is it possible to give a report a password , and if the password is wrong , the report will be cansel'd jan
|
| Like count on report header | 07 Jan 2005 18:19 GMT | 2 |
I have a report that I would like to ldo a like count on. I'm using the following code at the top of the form =Abs(Sum([RSID]="1D1*")) =Abs(Sum([RSID]=Like "1D1" & "*"))
|
| Close on the count code | 07 Jan 2005 18:12 GMT | 1 |
I need to count on the my RSID field. here is what im using. =Abs(Sum([RSID]="1D1*")) =Abs(Sum([RSID]=Like "1D1*")) Could not get it to work.
|
| Dividing by zero | 07 Jan 2005 17:39 GMT | 1 |
I have a text box that shows percentages from the value of two other text boxes, but when they both say zero (0.00) I get an error. I assume its because you can't divide by zero, so how do I make it show 0.00% instead of #Num!. When there are values other than zero it works ...
|
| Need docmd code to display multiple pages of report | 07 Jan 2005 16:49 GMT | 3 |
I am opening a report, maximizing it, and fitting it in the window with the following code: DoCmd.OpenReport "rptReportName", acViewPreview DoCmd.Maximize
|
| Need help with FORMAT syntax | 07 Jan 2005 16:24 GMT | 3 |
I have a calculated field on a report in access 2000. Currently, it goes to the attendance table and adds up all the hours for a particular student. It works fine but what I need to do now is add up all the hours WITHIN A RANGE OF DATES for the student. The query that runs the ...
|
| Report pulls from two queries | 07 Jan 2005 15:46 GMT | 4 |
Can I make a report pull from two queries. I tried creating and unbound report, and adding text boxes that I specify QUERY.FIELD in, but it just gives errors.
|
| What is a SUBREPORT? | 07 Jan 2005 15:30 GMT | 4 |
I'd like to get some information on sub-reports. The definition, how does one employ them, what "mission" is performed by them, and how to "link objects" (and why)? Do I need a separate query for one? Can I reuse the same query as for my "main" report? My reason for asking is ...
|
| sorting footers (summary) | 07 Jan 2005 14:58 GMT | 3 |
I group each sale unit and sum the untis sales, each month a different unit will be top earner.. I would like to show in decending order the sales leading units. I can do it in Crystal Reports easy, but need to do it in Access to keep each user in the loop. In effect I want to ...
|
| Losing Sort Order | 07 Jan 2005 14:38 GMT | 3 |
I've read the article "losing sort order in report". I have in addition a note: I provided a report, which uses order by in the recordsource. I am always assumed that that assortment and grouping delete the order by instruction, however in this report the assortment likewise
|
| Pop Up Form / Report filter | 07 Jan 2005 14:35 GMT | 3 |
I am trying to create a Pop Up form that has an option group to filter my query to produce my report. Does anyone have any tips/ suggestions/ or samples that I could look at ? Thanks,
|