I HAVE TWO TABLES
T1- FIELDS ARE- IDNO AND DATE OF OPERATION
T2- IDNO AND FOLLOWUP DATE AND FU TIME IN MONTHS ( FUDATE-DATEOF OPERATION
USING  DateDiff formula...

I appreciate if someone can help me to figure out a way to solve this
problem, it has bothered me for quite a few days now...
I have four fields in "MyTable":RecID, CustID,InDate and Comments that
document each record ID, customer ID, the date they checked in to the

I'm using the Default MS Access Sales by Customer reports.  Is it possible to
have a aging report by 0-30, 31-60, 61-90, 90+ with the total sales format?
Can anyone help me with this report. thank you.

I have a Report with series of subReports. I want to change the
"SourceObject" of the subReports based upon a value on the main report. On
the Report's detail section (where the subReport reside), on the event
"Print" I wrote the following code.

I'm trying to fit more rows of data per page on a report, however
resizing it manually in design view does not seem to help me reach my
goal. The text keeps getting smaller and smaller, and there's more than
enough room to allow for extra rows, yet there's no change.

Currently we output reports to pdf using a different product, and would
like to change it because some of the issues we are having.  I came
across ReportToPDF by lebans.com and would like to try and use this
instead.

I have several reports that print a message in the report footer.  The
message is the same for all reports.  Part of the message needs to change
based on certain events.  Now I edit each report and change the message text
before generating the reports.  I would like to put the ...

Using Access 2003
I have a report based on this query below.  It shows the names and years
worked for employees for the month I type in.  I would like to put a control
on the report that says "No Anniversarys this month".  2 problems.  I don't

I need to calculate age in a report.
I have one table with the following fields "FirstName", "LastName", "Age"
and "Birthday".  The Age column is blank.
I created a report using all the fields in that table.

I have a database I've set up that has a number of queries that filter
the data by two (or more) checkboxes. I'd like to set up some kind of
summary report that simply indicates how many records are in each of
those queries. I feel like this should be simple, but I'm not coming up

When I look at the properties for my report there is a filter and
filter on value.  How do I add a filter to this report.  I am unsure
what goes in the filter value.  I imagine I enter the name of a filter
in this box and put the filter on; but how do I create the filter

I'm buiding a report (that has subreports, unfortuneately) that i had to
resource to a Crosstab query - when I try to make changes in design view, it
is REALLY slow - is there a work-around for this ? I don't think you can make
a table off a crosstab - I was thinking about  ...

I am stuck in testing my project developed in DotNetNuke. I am tetsing
the project with NUnitAsp, a free testing tool for testing the Asp.net
projects. When I compile the project and add its dll to the NUnitAsp,
it searchs for Dataprovider, which comes dynamically in dotnetnuke.

I have a little script on a command button that prints the Class Attendance
sheet for the current class from a One to Many form that works great.
However, I want to add another condition to the report’s strWhere condition.
That condition is based upon a child table field:  ...

I have  three sub reports in one report.
I have separated the reports with a  page break, so each report starts on a
new page.
Here's the question.