I have a field in a footer that is simply just a total by day.  In a header
I'm wanting to sum this data by week.  When I run the report I get a prompt
to input the data.  I'm sure this can be overcome, but I just can't figure it
out.

Has anyone seen this behavior before? and do you know how to resolve it?
I've got a report that I just modified and moved from Portrait to Landscape.
After refomatting the page and moving controls around, I have run into a
problem.  When I try to render the report using the ...

Is it possible to hide duplicates but keep all dividing lines? (I need this
so that it looks like a table).
Thanks in nadvance for your responses.

I have a control on the detail section of a report with the control source
set as
=([TotCYP1]+[TotCYP2]+[TotCYP3]+[TotCYP4]+[TotCYP5]+[TotCYP6]+[TotCYP7]+
[TotCYP8]+[TotCYP9]+[TotCYP10]+[TotCYP11]+[TotCYP12]+[TotCYP13])

=SUMPRODUCT((Data!E$1:E$2514>=Lists!A13)*(Data!E$1:E$2514<Lists!B13)*(Data!K$1:K$2514="Other"))
I'd like to have this same number returned, but I'd like it to filter out
when
=Data!M1:M2500 does NOT equal "FA" or "Nonrecordable".

Could someone look over my database and see if they can correct an error I
made to it.
Basically i have created a clutter database to keep track of hospital
equipment that isn't in a place inside of our hospital. I go around on a

I am having trouble with getting totals from the subreports to the main
report.   If I have several pages on the subreport it only brings the total
from the last page of the subreport.    I have changed the running sum to
over all, but still the totals are not correct.     This ...

Access (2002, at least) seems to remember the order in which
fields are created in a report, and when tab-keying to
navigate, follows that order much the same way as forms in
form view.

I fould a post in which it was explained how to force backround colors based
on certain "text" conditions ... it went as follows:
Select Case Me.coname
Case "x"

I need help with LookUp.  I have used DLookUp() but this doed not work as
this gives me the wrong information.  The field information is correct but it
is for the wrong record.  How does Href (?) work?
Regards

I would like to display the FontSize and FontName for a labels report prior
to opening (previewing/printing) the report to enable the user to select from
alternative choices in combo boxes.  How do I access the current property
values before previewing/printing the report to ...

Greetings all --
I have an access database with a table field that's an OLE object.  The
content of this field is an embedded Word object.  (I'm cataloging bits of
SQL as I reverse engineer other people's handiwork.)  The Word object create

I have a report which is based on a query. The query has 2 tables tblFees and
tblLevy. One of the controls has an IIf statement as its control source. This
is it:
=IIf([tblLevy].[txtmemnbr] Is

I have a report with a footer , Information about my company, but my report
has a Sub/Report that mat stretch to 4 or 5 pages is it possible for footer
only to appear on the last page at the Bottom

Is anyone aware if Mr Lebans' PDF writer works with Access 2007? I've tried
his latest release to no avail in an ACCDE file, however it works fine in an
MDB file ...
I have briefly tried the PDF add-in for Office 2007 and it seems to be ok,