Hello, I am trying to get rows in a report to highlight based off of two different tables. What I need is: If ((Table A) and (Column/Category A)) are equal...

I am trying to 'x' out the first 5 digits of a social security number on a report and only show the last 4 digits. How do I do this?

I've got a report group that contains a #, Title, and a Description. I would like to print the # and Title at the top of each page where the Detail section...

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 simple flat table that has fields like date, description, work type, duration, etc. I want to have the report list all the entries in date order but...

I have used Duane Hookom's crosstab report samples at www.RogersAccessLibrary.com for dynamic column headings to get one of my reports that has different...

Hi. I need help writing an expression. On my report I have multiple cost codes/cost types listed as well as their estimated and actual costs. I have...

Elements and Structu I have a Crosstab query which selects data from a set of tables that hold all of the financial information for a particular program...

I am getting the message "Microsoft Office Access Has Encountered A Problem And Needs To Close" with the two buttons Send Error Report and Don't Send. Is...

I have a cheese database that I need to create an expression in a report to calculate the Average Moisture for only Vats 1-12 and then the remaining Vats...

I have a chart on the report and has child master link to the report. The chart shows my child field when the field is in my row source query. It lost link if...

In a subreport Sub I am trying to pick up the value of a field in the parent report, using Me.Parent!txtBox. I get an error saying You can't reference a...

I have a report that displays the month, year and a headcount sum for that month and year. The problem I am having is that if I run the report before I have...

How do you draw vertical lines on a multicolumn subreport. I only want two vertical lines. One on the left side of the report and the other on the right. The...

This is my first post so I would like to start by saying that this is a great site and it's amazing how helpfull, and knowledgeable, the contributors are. My...

Hi, I was wondering if i could get some help with Access Report. My question is whether there is a way of setting a page break or determine when it should...

I am wondering how can I create a query or report that concatenates all records under one field from a particular table so that they all show up in the query...

Hey there, I have a bunch of reports and this problem is only failing on 1 report and I can't figure it out. At the bottom of each report I have a text box...

I have been trying to set up a report combo box based on the instructions below that I got from a previous post. The name of my field that I want the combo...

I need help in choosing records that meet the following criteria: clients' children between 5 andf 11 years old; the problem is that the table has 6 fields as...