i have three different group of records with their related data as below:
Type   Xact   Unique    Gross
BIK       23       65        12345
KIS      12       34        12760

A Microsoft Graph Chart in a report uses the first column of a query to
populate the Category (Y) Axis. When editing the graph, the category names
appear as they should. When returning to design or preview the report, the
category labels disappear.

I am using access 2007
I want to string [Field1] and [Field2] etc to actually print as follows
Roger","Jones or
Paul","Morgan

I have a report (ACCESS 2003) that shows 6 columns of data on one page as a
quick reference and  was wondering if there was a way of shading every second
row,
as I find putting lines on the page clutters the page

I have a subreport that was intended to return at most 5 rows of data
but can now sometimes return 5-10.  As I don't have enough vertical
room to work with, would it be possible to wrap the data in columns of
5 records apiece on the current subreport?  ex:

Can you make the page header only show up on the pages two and on in
an Access report?
David

A2003
I want a calculated field to count number of unique Addresses (don't count
duplicates). In Excel I have a complex formula that works:
=Sum(IIf(FREQUENCY(IIf(Len([Address])>0,MATCH([Address],[Address],0),""),IIf(Len([Address])>0,MATCH([Address],[Address],0),""))>0,1))

Concatenate has opened a whole new world, but I have one question:
I am using Concantenate to create a string of roles together for a letter.
For example "Thanks for serving as Role1, Role2".
Is it possible to tell the report to insert an "and" before the last role so

In my form I have created a commnand button to preview a report but instead
of being in a document form how would I change it to be viewed in Excel for
Run time access users.

I can't believe there's no post on this, but I can't find it.  I've
tried the solutions I could find (see below) and still get the error:
"The expression is typed incorrectly or it is too complex to be
evaluated.  For example....Try simplifying...."

Is it possible me to create drill down reports in excel.  Suppose, I am
having a report of Monthwise Sales Trend in Matrix format ie. Months as
columns and Products as rows and data as the Units or Values in intersection
point.  If we double click the month say APRIL, a second ...

I am trying to build a report based on the input from a form (1 input field
only) where the users input could be say Rolling Stones or The Rolling Stones
or Stones. The report needs to be able to display all records with all or any
of these words.

I am trying to do a merge from Access to Word .. the information is all there
.. unfortunately my records are listed one per page (I only have 2 fields per
page) .. but I have over 1,000 pages .. it should be line after line .. as I
have it set on NO SPACING .. any ideas as to ...

I have a report off of a crosstab_query that picks dates from a table to
match with names in another table.  The query works, the report works...to an
extent.  I read here in another post how to change the forecolor and
backcolor w/VBS.  On my computer at home it works. On my ...

I have a field containing a variable-length string from 8 -17
characters.  My difficulty is that when I sort them, I would like to
group them based on on the section of digits just before the last.
The last digit may represent a change to the original.  For example,