My report recordsourse is based on qrystudent where i have 2 tables.
'duration' table has 2 fields [from] and [to].
on NoData event of the report, I want to give message like 'You have not
logged in during ' [from] and [to]

I'm having a problem with row numbers in a report with three
groupings.  The exact subject matter is a bit arcane, so as an example
I'll use taxi cabs.  My question is simple: how do I get the desired
result (listed third below)?  In other words, how do I specify the

I have created a detailed access report which I require to be sorted by
language (english and french).  Currently, I have created two different
reports and I run the report against two different query files -- one which
selects "E" and one which selects "F".    It would be alot ...

I am trying to get a field and its' label to not be visible on the subreport
if the field is null.
Does anyone know how to do this? Its driving me crazy.

Hi all,
I have a report that is about 15 pages.  Is there a way to export the report
to Excel, but have each page exported to a different sheet in one workbook?  
For example, Page 1 of the report is exported to Sheet 1 in the workbook,

I am running a report based on a query using the date selection criteria,
BETWEEN ---- AND-----. Is there any way of printing this date range in the
header of the report.
I would also like to take the totals from this query and put them into a

i put some code to display simple msgbox, and breakpoints in the 'on format'
event of group header where i have fields displaying, as well as page header
and detail..yet none of the breakpoints seem to fire..
(think i tried 'on print' also..

I am trying to print a report to the default printer on a client PC
and at the same time print the report to a pdf printer and save a copy
of it. My code so far is:
Dim dbs As Database, rst As Recordset

I have a query which is summing one field and counting another. In the 3rd
column I have an expression which takes the sum divide by the count
multiplied by 100 to give an overall percentage. It seems to work fin until i
add a fraction in like 0.5 to the summed field then the ...

I'm attempting to add a conditional format so that the "border" becomes
transparent if the value of a text boxis equal to "Y".  If the value is other
than "Y", then I want the border to show up.
I've attempted this code to no avail:

I have a text box in the report footer that I want to count the instance "Y"s
or "N"s in a text box in the detail section.
It should be as easy as  =-Sum([AttitudeComp]="Y"), but when I run the
report I get an input box to enter the parameter value of AttitudeComp.  I

Hello...I am using the code below to show a date parameter on a report. The
parameters are entered via a form...frmStaffFollowUp. It works well, except I
am trying to make a small change to no avail. When there are No Records
Found, I would still like the date parameter to show.. ...

I would like to know if there are more choices for conditionally formatting a
text box, besides font style/background color.  I am making a report to be
used for field input, and whereever a text box is blank, ideally I would like
to have the text box underlined, to bring it to ...

I have a report that prints two pages per column.  It is very simple, and has
no grouping or sorting levels.  Just the report header, page header, details,
and page footer.
I currently have the detail control labels in the page header, but they only

Any ideas about why adding a conditional format would cause a running
sum control to display "#Name?" instead of the running sum value?
Without conditional formatting, it works fine.
Condition statement:  [IS_PLACEHOLDER]