In Office 2003 you were able to export data in a report directly to Excel by clicking on a button. In Office 2007 the "Excel button" is grayed out when you...

I am trying insert a carriage return and line feed into a Access 2000 report text box using the following code: =IIf( Like "*service*","DO NOT USE RED BINS"...

Various reports started printing odd numbers of copies a few months back and I'm not sure how to rectify the problem. I have multiple databases/reports that...

I'm trying to add a subgroup to an existing report, which is currently grouped by County, then School. I want to group by County, City, then School. I'm...

I have an access report that prints a count of how many times a customer name appears in the table. Example Mike 4 Joe 5 Mary 1 I need to not print any...

I have a field called "Service Codes" from 1 to 99. Not all the codes are being used in a month. Is it possible to show in a monthly report only the codes...

I would like to get an opinion regarding strategy for sharing data within the Access database. I get increasing numbers of requests for data and would like...

I need to be able to take a group of records, get the number of people per group (from the user), and split the group of records across these new groups. Ie...

I am convinced, we seriously need to ditch our checkboxes. But I'll need to be able to have a report form that looks like we use checkboxes. Let's say that...

I have been researching this all afternoon, and I just can't seem to find the solution. I know what I need but I just can't get from point A to point B. I am...

Good afternoon, I realize there have been multiple posts on this issue, but I'm using MS Access 2000 and even after I do exactly what Allen Browne (among...

I am joining 4 tables(workorder, charges, parts, labor) to get the results. The results are as follows WO1, CHR1, Part1, labor1 WO1, CHR1, Part1,...

I have a table with different headings (ex. MS #, Ord, Prod, etc.) Each MS # does has a unique set of data. I have created a query based on that table, and...

I have a report with a text box on it. I have the control source set to this rather than a field from the table. =IIf(!=1,!,0) How come this prompts me for...

I have multiple records with the same information except for one field (Tracking No). I want to run a report that doesn't repeat the Weight and Cost...

I have a very vanilla application. I run a query against a table to select the records I want. I use the query to feed a report. There is absolutely no code in...

I have a Field on my report which has the following as its control source: =Nz(DSum("PackQty","qryPacksActivity1","PackId=" & & " And Between #" & & "#...

I have a report that has many sub reports that print in the report footers of the main report. in most of these reports I am summing and or counting things...

I have two reports: One that displays Investment information (potential aquisitions) that are being reviewed by an investment comittee, and another report ...

I have created a data-entry database. The users will enter data into the form that the database opens with. They will enter data into the primary form (top...