| Thread | Last Post | Replies |
|
| Print Report (2 copies each page) | 07 Feb 2005 23:02 GMT | 1 |
I have a report that I print from a macro. I was printing the report twice but I am getting complaints that the recipient wants two copies each page together, 1,1,2,2,3,3, etc. When I tried adding a table to the query with numbers 1 and 2, I got a
|
| Grouping | 07 Feb 2005 21:57 GMT | 1 |
I have a query for a record sorce. The query contains the following fields (totalsale, shipping, tax, JurCode, and Busstype). Each sale has a bussiness type and Juristicion Code. I want to print a report that will give me complete sums listed per the bussiness types and sums ...
|
| Calendar printing | 07 Feb 2005 21:48 GMT | 2 |
Can I print a calendar with all my Certified Public Accountants schedule's on one page?
|
| how to substitute names for digits in a header? | 07 Feb 2005 20:23 GMT | 1 |
In a report header (created by Grouping) I have a number instead of the month name. I want to replace the number with the corresponding month name. I have tried using this statement in the Control Source line in Properties. =IIf([Birth Month]=1,"January")
|
| Has No Data | 07 Feb 2005 19:37 GMT | 1 |
Hi I have the following statement in my report: =[Planned Budget] - Sum([Invoice)] - [dsum] + IIf([tbl_Budget_revision].Report.HasData,
|
| Custom Toolbar | 07 Feb 2005 19:04 GMT | 2 |
I have lost instructions on how to copy a custom toolbar as an entry into the properties of each report in my db. Cannot find it in Help. All my reports utilize this custom toolbar and I don't
|
| COMPARISON CHARTS | 07 Feb 2005 16:06 GMT | 1 |
Trying to compare data from different years for the same examination each year. Cannot seem to be able to compare data from more than 1 table. Have been able to create a report based on one years data. Have data for each year in a different table. Would like to be able to ...
|
| Cross Tab Query Question | 07 Feb 2005 15:35 GMT | 2 |
I have an enquiry table which keeps track of equipment quoted to a customer. I have the following SQL statement: TRANSFORM Count(qryForOverview.ID) AS CountOfID SELECT qryForOverview.tblCompany.strCompanyName, Count(qryForOverview.ID) AS
|
| Report Height limit | 07 Feb 2005 13:10 GMT | 2 |
Is there a way to go beyond the report height limit? Gal
|
| Average | 07 Feb 2005 09:44 GMT | 1 |
I have the following values in a calculated field. 10,23,NA,NA,23 . How to find the average of the above, ignoring the text
|
| report filter | 07 Feb 2005 04:48 GMT | 3 |
I created a report a long time ago and set a filter for it to open with. When I now look at the design of that report, I can't tell what the filter criteria was by looking at the report's property sheet. Is there another way to tell?
|
| formatting in reports | 07 Feb 2005 04:07 GMT | 1 |
I know u can left/right/centre/justify a cell contents within a reports. but how can u do the same as u can in excell, (vertical forematting) top/bottom/centre etc within a cell
|
| Report based on parameter query but displays data that it shouldn't. | 07 Feb 2005 04:05 GMT | 5 |
I have a parameter query that works fine. It use from three different coluns, date range , whse name, customer name. I built a report based on this query, however the report has information that should have been filtered off through the query. I ran the query and it selects the ...
|
| Calculate Mileage Reports | 07 Feb 2005 04:03 GMT | 5 |
I'm trying to create a table so multiple users can ask for mileage reports. Currently the database contains a "mileage" table that list the VIN, FLEET #, Drive ID, and a column for each months ending odometer reading. what i need to be able to do is give the user to ability to ...
|
| Running Sum | 06 Feb 2005 23:51 GMT | 3 |
I have generated a report of jobs completed for a week, by day. Each day is a group. I would like to show a total by day, rather than a running total as is given by the Running Sum. Any thoughts?
|