Reports

Report not printing all groups
I have an Access mdb which has a user form with 3 inputs and a button. After the user chooses the values for the inputs and clicks the button, I have VBA which connects to an MSSQL database, and executes a stored procedure using the values from the Access user form. The MSSQL stored procedure populates a table in t... 26 Jun 2008 17:43

Duplicate data in a report
Hi, Please bear with me, I'm new to access. I have a database that maintains information about local businesses offering students at our school work experience. There are three tables in the database, Hi, Please bear with me, I'm new to access. I have a database that maintains information ... 26 Jun 2008 12:34

Rolling Average Grouping
Hello, I have the following data that I wish to group on a report and find the cummulative average. Device # Date Trigger Amount 12 6/26/08 NO 100 12 6/27/08 NO 300 12 6/28/08 YES 200 ... 1 Jul 2008 09:14

Two Criteria
Background: My form has a subform each have seperate tables. The subform is for multiple entries linked to the main form/record. The challenge started with the need to generate letters (reports). In a text box, in the letter, I coded some conditions like:" & IIf([CA_NAME]="IR","Internal Review Committee"). I... 26 Jun 2008 16:41

border style alignment
I have a report like following columns and use boder style solid. Code Description The problem is when the description has 2 or more lines then the code still has one line of border. The first and second column do not have same border height. Are there any workaround for this? Your informati... 26 Jun 2008 14:38

Display certain data in a report depending on value of field in ta
I have 2 tables in my database - House Details and Owner Details. As the names suggest the House table lists all properties in a given area. The owner table gives all details of owner, name, address etc. In the House Table I have a field called "Owner Type" which can be either Full Owner or Partial Owner. ... 26 Jun 2008 11:32

Using ADO Recordset for Source of Access Report in .MDB file
I am new to ADO and am trying to use it as the source for my MS-Access reports in an .MDB file. I am getting conflicting reports as to whether or not that it possible. Can anyone point to an example of how to use ADO to source my report? Thanks, -- Tom ... 28 Jun 2008 11:40

Include linked document in report
I have a db that has records with references to documents (primarily Visio, Word, and PowerPoint documents) stored on the external filesystem. I'm only storing the paths to these references - I'm not storing them as embedded or linked OLE fields. This works well on my form, where I can store the paths to th... 25 Jun 2008 19:08

Report and subreport pulling from same query.
I created a sales report from a query where the user has to enter the month number he wants to see the data for (just using [Enter month Number] in my query to filter the month). When the user runs the report he is asked "Enter Month Number" and the report displays data as follow: Month of June Salesperson 1... 25 Jun 2008 18:06

Count distinct records to display in unbound field on a report
I have a report that I use to show grand totals from different queries. In the PCR table, I have a field "OrigVialBC" that can have duplicated entries. I wanted to obtain the total of entries for each OrigVialBC and did so by creating the query: SELECT count(Tmp.PCR.OrigVialBC) AS TotTested FROM [SELECT DIST... 26 Jun 2008 12:34