I have tried several ways to hide the label in a report when the
attached field is empty. I tried changing the field to a textbox and
putting in =llf([Noncompliant Materials] Is Null,Null,"Noncompliant
BOM")

I use this in an application.... great tool.
My issue is on everyone elses machine (5 in total) it works as predicted.
But on 1 machine it outputs 100+ pages to convert to .pdf, so I just have
the user cancel it.  The queries are fine (I checked) and as I said works on

In my Access report I want my currency symbols to be left aligned (just as
the currency button does in Excel).
Using
£* #,##0.00

Hi, is there any way of exporting an Access report to a Microsoft Excel
datasheet?
Thanks in advance,
AK

I have subreport with a header that should repeat with different
values, but only the first one is showing up in the subreport.
I should be getting this in the report:
Header: 1 text

I have a 12 page report that I need to print,  I was thinking that
there would be a few ways to go about this, one would be to have a
different grouping for each page, the other would be to somehow link
one report to the next, and another method I thought of was to create

Is there a way to force a group footer to print at the bottom of the page
instead of right below the detail Section

I have taken over a database whch has reports with line graphs in it.  The
charts are currently created by export query results to an excel file,
generating the graph using VBA and bringing the graph back in to the report
in an unbound object.

I have a report that calculates weekly payroll. It is broken down into 4
categories. Employees making under a specific wage, the OT for those
employees, Employees making over that wage and those employees OT. My problem
is if there is no OT for either group I get all #Error ...

Does anyone have an example of a query & report that is user defined monetary
amounts calculating current quarter and also previous quarters as a total?
(showing all records and not listing each quarter separately)
I really need help... I created a db and this is the only hold up ...

Thanks to your guys help, I now have a working report that "exports"
correctly, no blank lines.
  However I do not want user to have to select File, Export, select
parameters, or enter file name.

I've created a chart on a report which appears to display
and print ok when I've made a change to the chart, but if I
save the chart and changes, it displays incorrectly.
This report shows two charts per page, one with weekday data

Using this formula in a report:
=([FirstName] & " " & [LastName]) & Chr(13) & Chr(10) & [Address] & Chr(13)
& Chr(10) & [Address2] & Chr(13) & Chr(10)  & [City] & "," & [State] & " " &
[zipcode]

I have a report where I want to show all records. It's a quarterly report
where the user inputs the quarter they are interested in. What displays are
only the rows where there was activity during that quarter. I want to show
all. How can I accomplish this?

I have a report that shows 10 fields. The user inputs a date for quarter they
want to see the information broken down. There is a column that should show
everything up until the previous quarter (one total amount-not broken down)
and a column that shows everything up until the ...