| Thread | Last Post | Replies |
|
| Simple Floating Button ??????? | 21 Jun 2005 05:55 GMT | 4 |
How to create a floating command button so i can i press it in print preview? The command button is for closing the report. The command button shouldnt moveable. Any solutions?
|
| access 2000 label wizard | 21 Jun 2005 04:11 GMT | 1 |
In my database I have a field for title, first name, spouse's name, last name etc. I want to print First name & Spouse's name Last name (if there is a spouse. If there is no spouse I just want first and last name on label.
|
| Report printing specific records | 21 Jun 2005 03:17 GMT | 5 |
I basically need to be able to have a report to print out information from one specific record in the table, the Blotter Opened record, at the bottom of each page until it reaches the next Blotter Opened record and change the information at the bottom of the report to match the ...
|
| Sorting records by a calculated field | 21 Jun 2005 02:10 GMT | 1 |
We are running a competition in which entrants come from various schools. What I need to do is create a report which lists the top 10 entries from each school and then gives a total of the 10 so we can determine which is the top school.
|
| Multi-Column Report Problem | 21 Jun 2005 01:45 GMT | 1 |
Access 2003 I have a report with 2 columns, but the page header & footer and the report header & footer but only extend to the first column and not across the entire page.
|
| Can't see way to include outer join data in report | 21 Jun 2005 01:26 GMT | 7 |
My organization used to log tasks for projects in a spreadsheet. I convinced them that a better process would be to create a database with a small data entry utility and then simply run reports instead of creating a new spreadsheet every month.
|
| How to eliminate space when field has null value in text string? | 20 Jun 2005 23:03 GMT | 3 |
Some of the fields in my text string will be blank - can I design it such that the space of that null field won't take up space in my report? Here's what it looks like - "Guaranteed Lump-Sum - $150,000 payable on 7/1/2015"
|
| Charts in reports | 20 Jun 2005 22:49 GMT | 3 |
I am trying to build a chart where the data comes from a query. I have tried this in forms and in reports. I am using the chart wizard and all works great. I do a preview and it is exactly what I want. I finalize the chart wizard and then appears the chart that is completely ...
|
| rounding is ignored in calculated control | 20 Jun 2005 22:25 GMT | 4 |
I've put a calculated unbound control on report but it seems to be ignoring the rounding. Here's the formula in Control Source property: =Round([Calls]/[Total Calls],2) It's then formatted as Percent with 0 decimals.
|
| How do I display leading zeros for a numeric field in a report? | 20 Jun 2005 21:31 GMT | 1 |
In order to have output conform to a template, I need to have a numeric field display with leading zeros to always fit a predefine 8 character wide space. e.g. 17.50 needs to be output as 000017.50 ideally as 00001750 or 132.45 would be 000132.45 or ideally 00013245
|
| report based on a 2-columns lookup field | 20 Jun 2005 21:17 GMT | 1 |
I have a table with several fields among them, there is a lookup field named [Contact Code] with 2 columns. Not all the data uses the two columns only the Internet does as follows: col 1 col 2
|
| screen resolution/ About Blank | 20 Jun 2005 20:34 GMT | 1 |
I have checked my system with every virus program I have NAV McAfee both up to date subscriptions. My screen seeting will not change when I click the advanced tab and set it to not reboot or to reboot when I reboot the screen resolution is the always the same. When I start my PC ...
|
| Easily changing report format or sorting | 20 Jun 2005 19:31 GMT | 4 |
Once you have already created a report through the wizard, selecting the format, sorting, etc. for your report, is there an easy way to change any of this? Example: You have a list of employee names grouped by their supervisor without any sorting. After creating the report, you ...
|
| Date Range in a Report | 20 Jun 2005 19:03 GMT | 2 |
I would like to print a report for a specific date range. I have many queries which are subreports in my main report. In these queries there is criteria of "start & end date" so when I run a query I get information from that specific date range. However, when I run my main ...
|
| How to get rid of the decimal places in a report calsulation/text | 20 Jun 2005 18:38 GMT | 4 |
For example, I want to have the report calculate a person's age - I did this as follows: ([today] - [date of birth])/365 which produces ia number like: 50.1457899 -so in "properties" I made the number standard with 0 decimal places - but now I get 2 decimal places: 50.62 - I'm ...
|