Reports

table/reports images
I have tried alot of things to get my images from my product table (each product has its own picture) to show up on my report. The only thing that shows up is the file path. I have never done anything like this in access and have only basic access training. If anybody can help me with this, in easy and si... 5 Jul 2008 00:19

Saving Printer Driver
For the life of me, I can't get my report to save the printer driver I assign to it in the page setup. Is there something I can do through vb code to assign the code? Help! -- Don Rountree ... 2 Jul 2008 00:39

Printing Individual PDF Reports
I have tried two sets of codes for printing individual Access reports to PDFs that I can not get to work. Your help would be most appreciated. First: Dim dbs As DAO.Database Dim rst As DAO.Recordset Set dbs = DBEngine(0)(0) Set rst = dbs.OpenRecordset("SELECT DISTINCT [ID] from qryEID", dbOpenSnapshot) ... 1 Jul 2008 16:27

Comparison Report based on a query of only calculations.
Good morning, We have an access database that has the tables, forms and queries all completed. We have a small portion of the data entered to test things out. We need to create a report that is comparative by year and by number of cows. We would like to have the number of cows be in groups as listed below:... 18 Jul 2008 16:30

Open Report - using a selection made by combo box
Hello, I am trying to get Access to preview my report for a selected practice. I have a form with a combo box (Combo0) and a command button (Command0). The combo box has two columns, one for the PracticeID which is an autonumber and one for PracticeName that the user actually sees. The row source is as foll... 1 Jul 2008 13:22

Not display repeated values in a field
Is it possible to hide duplicate values from a single field in a report WITHOUT using groups? ie if I have the following Tesco Fred Bloggs Tesco Jane Smith Tesco Jack Frost So that the result shows as Tesco Fred Bloggs Jane Smith Jack Frost rather than the group header which displays o... 1 Jul 2008 12:20

Parameters requested twice when opening report
Hi, I've created a form [Select Name] which ask for a name to be select from a combo box to run the query [Overdue & Due Actions] which then in turns runs the report but when it runs the query, which I see has run correctly, it then asks for the name again but this time I need to type it in. If I don't enter ... 1 Jul 2008 11:18

Chart based on data from report
I'm looking for an answer how to make a chart in the report, but this chart has to take data from cells in the report. I have a report that collects data from queries and make a some mathematical operations on them. At the end of the report I make a summary of the data (also data which comes from mathematical o... 2 Jul 2008 09:50

Show query Parameter in Chart?
Is it possible to display and print the Query Parameter on a chart? I would like to have the Year and Month that the user selected displayed and printed on the chart! but can't figure out how. Here are the two query fields and the parameters. Query is: Year: Format([dbo_FRDF_DETAILS.RECORD_CREATE_DATE],"yyy... 3 Jul 2008 18:41

Report with Monthly rows, Yearly columns & 3 pieces of data pe
This is a little tricky but works really well. Thanks for your help. Mark "Allen Browne" wrote: A crosstab is the most obvious way to get each year into a column of its own, but the issue here is that you want 3 values in the matrix: AmountDue, Fee, and Payments. For just the AmountDue, y... 1 Jul 2008 02:05