Incerting a Column in the Detail sectio on reports (Access 97)

Topic

New Reply

To Whom It May Concern:

We purchased a program called QuoteWerks that is Access 97 Based. My boss want me to make a report for our quotes that in the detail part there is a column on the right side that we can have key points of our products. As far as I know it can

Reply | Quote

Replies

What’s the connection with FoxPro – are you saying that the tables are FoxPro tables linked to an Access front-end? If the reports are actually written in FoxPro, then you have a major challenge – about the only thing you can do then is to print it to a file using a very simple print driver, and then go in and edit the file after the fact to include the data you want – all in all a very ugly process.

Reply | Quote

Are the left hand column (quotes) and right hand column (key points) to be coordinated? If so, you might get by with a single column report that fakes two columns.

If the right hand column is to contain fixed information, I don’t think you can do this with regular report columns. Ideas for wrokarounds (not tested):

• Create a picture containing the product key points, and use this as background picture to the report.
• Use the Access data as data source for a catalog-type mail merge document in Word; you have much more freedom for document layout in Word.
  [/list]

Reply | Quote