I created a grouped report with the wizard and am changing the layout.  The
wizard created a landscape report with lines at the top and bottom, which
print on successive pages without data (because of rearranging the controls).
I managed to delete the line in the header, but I ...

I have a customer that are moving from Windows XP and Access 2000 to Windows
Vista and Access 2002 SP2. When moving the main database to the new
environment something "happens": All reports disappears. The names are still
there but I can't see them using the design view. I then ...

Can someone help me with the proper code in order to use multiple multiselect
listboxes to limit records in a report.  I want to have two listboxes, one
with contractor types and one with regions.  I want to pick options from each
listbox and limit my report based on both.

I currently have a field on a report that shows LastName, Suffix, FirstName
MI.  It is set up as follows:  =Trim([LastName] & (",  "+[Suffix]) & ", " &
[FirstName] & (" "+[MI]))  
This shows the name and if there is no suffix or middle initial it doesn't

How do I put a permanent frame to a report?
I have problems with the right & left lines.

I am trying to get access to display the Compliant ID's that I'm
importing from excel to access in a table named Duplicate.  The reason
for the error is because I am importing various complaints an some of
them will be duplicate if reassigned, but I can't delete the duplicate

I have the following formula, which works correctly, in a report I have
created.  I use the same formula layout for a number of fields.  What this
formula does is take the readings from 3 different phases from an electrical
breaker, and returns the highest.  I do this same ...

I have a text box that I want to report a certain field for most records in a
query, but when it gets to certain records it needs to report another field.
Therefore I have put an IIF statement into the textbox. It produces "#error".
While troubleshooting it I realized that the ...

I'm trying to create a list of competitors in an event, some of whom belong
to teams, others don't. I'd like to show all the competitors, regardless of
whether or not they belong to a team, but when I include the team field on
the report, it only shows competitors who belong to a ...

Don't know if this is a query querie or or report querie but here goes: I
created a summary query from a table that has 4 fields. The data source on
three of these fields is table/query. Meaning the value that is actually
stored in the original table is "1" but what displays in ...

I am trying to create a Crosstab report where I would like the detail row
headings to be the same for all my groupings. I found the Help About for
'Creating Crosstab Reports' but the last 2 steps are very unclear to me. My
crosstab query looks like this:

How do I create a circle around some text on an an Access Report?

I have a list of customers and each customer can have a number of processes
lasting different times. On my report, I can average each customers processes
and get an average time by using in the Customer footer of my report:
=Int(Avg(qryCARR!DurationInMinutes/60)) to get the ...

Recently i made report based on crosstab query,
Columns represent quarter of year in conjunction with data about expenses.
Problem is that crosstab query, i mean Report in connection with that query
works only if there is inputs for each quarter of year.

I'm running Microsoft Access 2003 Sp 2 and the Vertical Property for a label
or text box does not seem to work at all. I set the Vertical property for a
label to Yes and the value in the label disappears. Am I doing something
worng or is this yet another Microsoft bug? Thanks.