Can I group fields in a report that have memo data types?  I’ve tried
unsuccessfully.
My objective is to create a report based on a query that includes the fields
indicated below:

I have an access query which generates a report based on the user entering a
value for one of the fields (@session).
Rather than have the user type in the value of @session, I would like them
to a value from a list box.  The list box should be populated by another

When I open my access 2000 report, I need its default orientation to be
landscape. Right now, I have to go to file->page setup-> and set it to
landscape every time I open my database. Is there some VB code that can
resolve this issue? Also, when I print the report, it prints ...

I'm using Lebans code to produce PDF. My problem is that the graphics, lines
etc are not exported. Can anyone help?

I get a parameter prompt in an Access report when the trim function is and A
"#error" results.  This also happens in reports created by Access using the
lable wizard. Other functions, such as "Left" also result in a "#error"

I have 3 queries based off of one table.  They each have the same named
fields but some formulas are different.  I want to get all three of these
queries into one report. Can anyone help with how to do this and what to use?
Thanks in advance

I have a CONTRACT Table as follows:
Contract # (autonumber - primary key)
TV            (Y/N)
Satellite    (Y/N)

I've recently offered to design a database for a small company. Not
having touched SQL databases for years and years since college, it's
been quite a steep learning curve. One problem has eluded my attempts
to track down a solution on the Internet...

I have a report that tracks the files that are "in house" for porcessing.  
The report shows all our clients whether we've received their files or not.  
Once we receive a file, a date is entered into the database.  
I'm using:

I'm working with Access 2003.
I need to create a column report with equal lenght columns in a down and
across column report. The lenght of the columns is not directly related to
the number of rows of each section.

I'm encountering an issue where the performance of Access slows significantly
while I'd editing the design of reports based on either cross-tab or
pass-through queries.  Unless I "break" the report by renaming the record
source property, it will stop responding for up to a minute ...

I have two separate text boxes in a report.  I have put an expression in each
box being:
=IIf([ManageAnnualSum]=Not True,0,[ManageAnnualSum]/4)
and

I have a series of reports that I need to run. however they need to have
concecutive page numbers. Is there a way to have all my reports i need to run
in a macro and have the page numbers be concecutive across all the reports?
Thanks much,

I'm a little new to using Access, but I have created about five databases for
my work.    However, I'm unable to format an Access text box with the same
format that I use in Excel.   To give an example, say I enter the following
data in an Excel spreadsheet: