I get an error message "the expression is typed incorrectly, or it is too
complex to be evaluated..." when pulling a report. I think it has something
to do with the dates but I do not know what. I was working until I tried to
pull reports for October. The parameters ask for a ...

Hello -- This is my first time asking for help, and I think my first post
didn't go through.  If it did, please forgive me.
I hope I am making sense here -- I have a form with a combo box for users to
select a reporting date.  That date is passed to a report that is based on a

I have a report with a "booth" header and "coll" header with three columns.  
I would like to page break after each change in booth.  It's only column
breaking for me.  For instance, booth 1 breaks in the middle of column 2 and
booth 2 starts at the top of column 3 on page 1.  I ...

I have an option group on a form and would like it to display on a report.
How do I add a option group to a report?

I would like to print only ONE copy of a report, by using a command button,
from the data that I have displayed on the screen.
I have an input form that collects data onto 14 fields.  I can save that
data onto a table.  I WISH TO: Print ONE copy of a report of the data I just

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?
The query has the fiollowing code for the TRANSDATE parameter:

How do I sum the amount of  time on a report if timein is 7:42 AM and
timeout is 12:33 PM. Is there a easy way of doing this?
Thanks

I have a database of books I own in Access/.Office 2003..  I have a query
that seperates a specific genre (sci-fi, mystery etc) and I have designed a
report to print a list of one genre or a  combo or a complete listing.  One
of the feilds for each record is a ONE character field ...

I have created a report that has entries 1,2,3 and 4. I want to add a
subreport which has 2 more entries. However, when i try to do so, the entries
for the subreport show up in between those on the report. This is not what i
want. I want the subreport entries to show up below ...

In an Access 2003 report which has a summary section which Sums a
value in the detail section, when there is no data #Error appears at
the Sum(myField) section. There is no sub reports on this report.
How can the #Error text not be shown when their is no data?

I have a report where names are underlined if certain conditions are met.
When the report displays on the screen, before the user selects print, and
before the user clicks it to make it large, the last visible underlining is
not there (i.e., say 5 out of 10 rows need underlining ...

My database has a field that is a drop down box with four building names.  I
want to sort the report by building, but I don't want the buildings in
alphabetical order.  How do I sort/group that field so that the buildings
appear in the specific order that I want?

i have a report that has many things going on..however,
i need to know what's wrong with this?
=DCount("[reviewmonth]","databaseqry","[reviewmonth] and [14a]='1' And
[Hospital] = '" & [Hospital] & "' And [auditdate]="Between ' & [Beginning

I am wanting to repeat a header on a report to the next page but the
repeat section option is not available when I double click on the
selector for the properties box? any other way of doing this.

I'm building a customized payroll report in Access in which some of the
headings have a vertical orientation. The problem is, I haven't found a way
to change the direction of the vertical text. I'd like this text to be read
from bottom to top. So far, I can only produce ...