How can I show the "last" date of a record in a report? There are many
entries for one establishment, but I only want to show the last date per
establishment.
Can I do this in a report, or a query to a report? Gracias!

I am using Microsoft Access to generate a report in the
style of a payslip.
I have sections outlined with fixed size boxes and when a
particular section has too many records it needs to flow

I'm trying to do the following in a group footer:
=SUM(IIf(DateDiff("d",[FinalPaymentDate],Now()+60)
Between 1 And 60,[AR],0))
when I do this I get an error that says "Aggregate

I need to report onto a landscape page with 3 detail records ACROSS the page,
next page to show next 3 and so on.  I think I need 3 sets on text boxes in
the one big detail section but how do I get Access to step to the next record
so I can manually load up the boxes.

Hi ..
I have a code allowing users to choose printer for
printing a report. To do this, the report must be opened
in preview mode..But how do I close the report, it locks a

How can Show the parameters of a query on the report.  Thought i should be
using the 'control source' function.
Thanks for the help
Pete

I have a report that has multiple groups.  Detail, YearFooter, ProjectFooter
and Department Footer
In the ProjectFooter, I have a text box where I am using a function to
calculate available workdays between 2 dates (Function taken from

HI, is it possible to preview a report and make it popup and modal or
preview a report in a form ? I really need to do this modal, because I am
hideing the Access Window...
Regrds

I can create queries that will give the count of various
option boxes.  How can I put these multiple queries into a
single report?  The wizard says I have chosen fields it
cannot connect.  

Hi Duane:
What you suggested here is very good. But our report also
needs to include percentage, average for each item.  Can I
use multiple queries for ONE report?  Thanks.

I have a report that lists instructors & the classes they have taught.  Each
detail section ends up being a different height based on the number of
classes taught.  The report is grouped by instructor & I always get 2 groups
per page or piece of paper.  What I'd like to do is be ...

Hi Marsh:
Thank you very much for your suggestion. But I am not very
clear about your expression. Could you give me a little
bit of further explanation?

I have a report based on a form with a subform.
The basic idea is that the subform will look up the contractor address from
the contractor table, and I have a query that does that.  
This appears to be working fine on the form, but when I build the report,

Is there any way I can demonstrate the cut office point
for top 30% percent?  For example,  I have a variable
which has values like, 1,2,3,4,5,6,7,8,9,10.  We know 8 is
the cut off point value for top 30%. Is there any way we

I have used the Report Wizard to create a report - its in
portrait format.  I have arranged all the fields to fit,
but as I print it out, I am getting 3 blank pages in
between each printed report.  How do I remove those blank