| Thread | Last Post | Replies |
|
| Please help with number formatting | 24 May 2005 21:31 GMT | 1 |
I have created a chart in an Access report. I have picked the option to display the datatable with the chart. All of the data being displayed is stored as the currency format in a table, but when I do a print preview of the report the numbers in the datatable have no formatting ...
|
| Formatting Z-Axis Scale on Report Chart | 24 May 2005 21:16 GMT | 1 |
Hi. I have a chart in a report which displays dates along the Z-Axis. I'm trying to display a date for every Sunday in the series of dates. I've formatted the Major Unit of the axis to 7, displaying dates on every 7th day. However, the chart is displaying dates for ...
|
| Creating forms and labels using different criteria | 24 May 2005 20:27 GMT | 9 |
I have a database that I need to create multiple labels with different criteria. I’ve used label wizard for all my addresses but what if I want to make labels for a specific state or zip. The database also has the person’s birth date.
|
| Date Range IsLoaded Error | 24 May 2005 19:37 GMT | 1 |
Database is based on my employee's work log. One table, named Tasks with rows of TaskID, Task, Notes and StartDate. I have entered test data for different dates to test out the database. I have a report that can print out the entire database and a report that prints out only ...
|
| Pie Chart in Report | 24 May 2005 18:28 GMT | 1 |
This is my first crack at developing reports in Access. We're using a Access 2002 project and connecting to SQL Server 2000. I have an extremely simple subreport that contains one Pie Chart. The pie chart needs to show two values as a percentage of the total; i.e. if Jobs
|
| Displaying Data as a Pyramid | 24 May 2005 17:21 GMT | 7 |
I have a Sports Club database. The club runs a Pyramid Challenge System whereby members are ranked and then arranged in a Pyramid (highest ranking at the top). Members can challenge the person immediately above them to a match and if
|
| Len([Name]) doesn't work in access report | 24 May 2005 17:16 GMT | 2 |
I have field [Name] with length 200 in access report. When I try to calculate the number of symbols in the field with Len([Name]) commnad, every time I receive 4. I tried with different data types for [Name] - nvarchar, varchar, char, nchar, text, ntext, but every time I receive ...
|
| Adding two fields from a crosstab query in a report | 24 May 2005 15:44 GMT | 1 |
I am trying to add field1 and field2 together into field3. Field1 and field2 come from a crosstab query where I used the formatnumber and nz functions. When I use the following expression for field3 I get bad results as if it is adding text together...
|
| transfer reports from one database to another database | 24 May 2005 15:20 GMT | 1 |
I have an old database with several reports. Now we have a new database, but we have no reports. So is there a way that i can use the reports from the old database ??? thanx Jurgen
|
| Using Filtered Form to Filter Report | 24 May 2005 15:16 GMT | 5 |
I have just started converting an Approach application to Access 2003. The old app had the ability to use the recordset from a filtered form as the recordset for the report. If the recordset for the form was "all records", and the report called up,
|
| I deleted a report that I needed | 24 May 2005 15:10 GMT | 1 |
Is there any way to get it back/ copy it to the original floppy that was send to me? or creat a new report where I can enter the exact micro
|
| check boxes in reports | 24 May 2005 14:59 GMT | 1 |
When I export reports over to Word, the check boxes do not come with it. Is there a way for the check boxes to export over to Word?
|
| For report with multi-types, only show first occurence of Cust Nam | 24 May 2005 14:26 GMT | 1 |
For example, if i I have the following table as recordsource: Type Cname Amount Sales Jay 8 Sales Jay 7
|
| create smart labels at runtime using vba | 24 May 2005 12:25 GMT | 4 |
I would like to create smart labels on a report using code, at run time . Anyone colud help me? Thanks in advance. Frank.
|
| Custom Paper Size | 24 May 2005 08:55 GMT | 2 |
I'm trying to set a custom paper size in an access report also, the printer I'm using is an Epson AP2000, however, the printer driver is generic and does not let me define a custom size paper, what are my options now? Thanks
|