I've created a report that looks like a standard form used by my company to
order equipment. The standard form, however, has empty visible lines (like
Excel) to the end of the page if the records does not fill it up. is it
possible to print lines in a report that does not contain ...

I have inserted a unbound text box in a group footer of a report. The
formula is to pull up a value from a subreport. It works fine except when
the value is zero or blank, I get the #Error.
I tried including an IIF and it makes no difference.

Access 2003. Creating report based on a single table. Table consists of a
field for a name and 25 fields that are all Yes/No checkboxes. The report
must show detail on the different subsets of the data based on the number of
"Yes" choices to checkboxes. An example would be the ...

I can't control the long date format as "mmm d yyyy" on one of 4
computers.  I have set a control containing a date to the "long date"
format.  On three computers, when I look at the format pop-down box,
long date shows as March 18, 2005.  On the fourth computer, the pop-down

Iam importing a ISAM FILE to Access and then trying  to create a column
graphic using access. as part of a report. using the student database, so I
can establish how many were man and female.

I have the following string in a textbox in the report header:
="Schedule Summary for " & Format(Now(),"dddd"", ""mmmm d"", ""yyyy")
Instead of useing the now function I have a global variable that is
populated before the report is run with a date.  How do I get this string to

I have created a report that gives me budget information from my tables.  I
also created a query (qry_equipment_amt) that displays records with Invoice
Amounts.
I created a DSUM expression and in my report I have data grouped by

I have created a 3 columnar report, however, the first column is blank.  The
data begins in the second column position.  What am I doing wrong?
Thanks for any help.

=Nz(DSum("[Allocation_Amt]","qry_allocation_partner_equip","[Partner_ID] = "
& [Partner_ID] And "[InvoiceDate] Between #4/1/06# and #31/3/07#"),"$0.00  ")
I have the following statement in a text field of my report.  It gives me
the sum of all partners.  I only want the amount if ...

I have a report based on a crosstab query. I added a text field to the detail
section of the report that does the following:
=Nz(DSum("[InvoiceAmt]","tbl_Invoices","[InvoiceDate] Between #1/4/05# And
#31/3/06#]"),"$0.00  ").

I need to create a form that shows multiple records but has them going across
the page horizontally instead of vertically.  
Essentially
HEADER

Hi
I am having much trouble with displaying a cross tab query in a report, I
basically have a tbl (tbl expenses categories) that stores the names of
expenses categories such as business travel.

I have created a report where it gives the balance of the planned budget per
fiscal year.  The report genereates a form when open that asks the user to
enter a fiscal year ex: 0506 and based on that response outputs the total
budget.

I have a report that contains 10 columns of data for each row. I don't
always need 10 columns, however, so in the Report_Open event I am hiding
some of the columns. I also shorten some lines by the width of the hidden
columns. When I run this report by itself everything works as ...

I am trying to post a memo field from the database we have into a report, but
the report doesn't show the complete field data?