I am struggling with a problem with an Access report.
The code I am trying to use is currently in use in another Access database that is doing exactly the same thing. Over the years the older database has gone through many changes. I am attempting to create a new database that has less unnecessary code.
I have a large table that original was a csv file from a service provider we use. I have multiple queries and a few tables that are used in the database.
The report I am struggling with will show detail based on individual dealer (customer). The table needs to show the subscriber account number, the item number, the fee for the service provided and any overage charges form our provider. At the top of the report we want the dealer name and the invoice date.
Attached is the code that I have been using for the old database to accomplish the report I want but this doesn’t work for my new database. Also attached is the report. I would be happy to send the complete database with all of the data to anybody who wants to look at this but I don’t want to attach the complete database to this message. The two items that are commented are the Dealer List name, the new database is using a different name and the DealerID is text in the new database.
The results I am experiencing is that there is no separation between dealers. Every report is exactly the same, even the dealer name does not change. Every report has all of the history covering all of the dealer activity.
The PDF report name is correct, it has the dealer name followed by “.PDF”. So this element works correctly.
Any help is appreciated.
The code I am trying to use is currently in use in another Access database that is doing exactly the same thing. Over the years the older database has gone through many changes. I am attempting to create a new database that has less unnecessary code.
I have a large table that original was a csv file from a service provider we use. I have multiple queries and a few tables that are used in the database.
The report I am struggling with will show detail based on individual dealer (customer). The table needs to show the subscriber account number, the item number, the fee for the service provided and any overage charges form our provider. At the top of the report we want the dealer name and the invoice date.
Attached is the code that I have been using for the old database to accomplish the report I want but this doesn’t work for my new database. Also attached is the report. I would be happy to send the complete database with all of the data to anybody who wants to look at this but I don’t want to attach the complete database to this message. The two items that are commented are the Dealer List name, the new database is using a different name and the DealerID is text in the new database.
The results I am experiencing is that there is no separation between dealers. Every report is exactly the same, even the dealer name does not change. Every report has all of the history covering all of the dealer activity.
The PDF report name is correct, it has the dealer name followed by “.PDF”. So this element works correctly.
Any help is appreciated.
