In my table I have NextDueDate I want only the current Next Due Date to
display in my report page header how do I accomplish this?

I am new to posting but lots of other experience to share.  I am looking for
the directions for using the calendar control as the opening parameter when
users run the report.  
So they open the report, calendar pops up and they select the report period.

I would like to scan in a page (let's say a form to be filled out to order
something) and populate the blanks with data from my DB. I could do this with
a Word template and mail merge feature. Or I could develop an Access report.
It seems like Word is faster and more versatile.

I have posted this question before but I seemed to be having some difficulty,
the page kept indicating that it could not display my posting. As a result I
have reregistered, so anyone who replied please do not be offended.
I am try to produce a chart in a form developed from a ...

Hello, I have a report in Access 97.  There are vertical lines in the detail
section that are between text boxes.  The text boxes are set to grow, so when
the data wraps to the next line, you have have space in the vertical line.  
How do you get the vertical line to grow with the ...

am trying to put a parameter in the SQL of a query to allow criteria from a
check box. Where the check box is selected it should only return data from
the query where the field = Yes. BUT when the check box is not selected i.e.
it is “no” the query should return all records whether ...

I have been trying for days but I am not that educated on Access.  I have two
queries that each take different product names and attach them the customers
table and also attach to the product prices.  I had to create two different
pricing tables..too long to explain.  However, ...

I have 2 controls in a report that are bound to columns in a table. Under
certain circumstances I need to load these controls with different data. I
tried to do this in the FORMAT event but get an error saying the 'control
source' cannot be changed after printing has started. How ...

I have a table I am using in a report with unbound controls to show counts of
various true/false fields in the table. I have a field called
tblProcedureCapture_RAA #2 and I am trying to count when it is true. I have
tried DCount, Abs(Sum([tblProcedureCapture_RAA #2]),

We have a complex SQL Server based system in which reports are
automatically opened, then exported to PDF based on 'where' criteria.
I have pinpointed the problem as the following segment of code:
docmd.openreport strReport, acNormal, , strWhere

I would like to automatically get the Report Title and Filename to show on
the 1st page of an Access Report or at the bottom on each page in the footer?
Is there a simple function that I am missing?

Hi all, hope you are well.
Simple question:
I have a table:
Username        

My report groups by City and client ID.  There are several clients for each
city and each client may have one or more records which are easy to count and
total, but I need to count the number of clients (client groups) for each
city.

I cannot run reports or create reports in Access 2003.  The only thing that I
have done most recently is open a database that was recenlty converted from
97.  It was a database that had read only properties.   I have unintsalled,
reinstalled Office 2003 with no luck.  

I have a Crosstab Query that I want to base a Report on.
Crosstab Query is as follows:
City  Number 22/08/05   23/08/05 .........................
CityA  100     30%             31%............................