I have report listing all the print times for jobs. I need
to highlight each job if the print time is over 15 days.
Problem is if any jobs are over 15 days, the whole lot is
emphasised (bolded).

How I can print current month and year at the header of the report?
Thankx

I need to summarize a field for a group footer. This report, however, does
not use detail lines; it consists entirely of three groups. I assume that
the absence of a detail line is causing the usual group footer total
mechanism to not work. However just to be sure, I will explain ...

I use a parameter query to obtain the data for my parent report. I need the
subreport in the report footer of the parent to also adhere to the input
criteria.
At the moment the subreport is only returning data for the last record that

I placed this on the forms NG, but then I decided that it
is better placed here.  So, here it is.
I hope I can explain this.  I have a form that a user
completes and then clicks on a command button to produce a

can anyone help me
what i am trying to do is create a report from a form
everytime i update a field in the form i want the report to show the correct
result

I have a database that consists of two tables.  I have
linked the tables, queried the two tables and I have the
information I want.  I want to report on the query.  
Here's where I have the problem.  The information in table

I declared a public variable strUserID in a module. In my
query, I would like to use this variable as the selecte
criteria. Like select * from table where userID =
strUserID.  In the module where the code runs to generate

I am trying to write Instructions for a database that I built. I started
writting them as a report but it will only allow me to make it so big. I
haven't used Data Access Pages yet would this be a better route to go. I
don't want to put these over the internet I just want them ...

 I have a query suppling the data to a report.  But I need to check the
next record to compare dates.
Can I do this without using ADO and its syntax?
Philip

I have a parameter query which has the criteria that
is "Between DateAdd("d",-2,[Type in the date]) And DateAdd
("d",4,[Type in the date])". It shows total 7 days in row
when I type in specific day.

Hello to everybody.
I would like to hide a subreport when it has no data to show and hide a
checkbox when the value is No.
It is possible?

I have an Access database, queries, and reports that I
have used for sometime.  Now, all of a sudden, when I try
to open one of the queries or the reports, I get a
popup, "Enter Parameter Value".  If I enter cancel, the

In Access 2003 when I preview a report, it sometimes
displays in a microscopic font.  When I resize it, I can
see it but it will still print in the microscopic font.  
Is this a known bug (I haven't seen any reference to it)

Access sub-report Sorting
Help!!! I am new to MS Access 2000 and am not sure if I am asking this
question correctly. But here goes. I have three reports with a common
relationship (one-to-many) and would like for my report to group a section of