Can you use a select query as a filter in a report? If so, please help with
the syntax. I tried putting in the properties and could not ever get the
syntax to work. I am not using that query as a source for the report. Thanks
so much!!!!

frm_courses, sfrm_participants
When I enter a new course into the frm_Courses and begin to enter names into
the sfrm_participants, I'd like for those attendees that have attended a
course with the same name/code to be identified in some way.

I want to create a report that compares values in 2 sequential records from a
table, then decides whether to print the pair of records (with a descriptive
message) or whether to print nothing for that pair of records.  I have plenty
of IT experience, but little Access and no VBA ...

I am a novice on Access.
I have a table that inputs a date and a daily market value for different
stocks/shares
I have a second table that inputs purchases and sales each day of the

I have a report which includes field which may not contain any data. I've
tried using the "can shrink" property on both the text box containing the
data as well as the section of the report in which this field resides, but
nothing is suppressed - I wind up with useless space.

I wrote a database that, among other things, prints a variety of reports for
my clients.  Once each report is done, I run  a program called pdfWriter to
convert each report to a pdf file.  (When this program is installed, I select
the printer called pdfWriter then print the file. ...

I have a database that contains the following fields, some of which  (all
fields starting with Page_) are selected via check marks;
ID, Date_Received, Site_Number, Subject_Number, Subject_Initials,
Page_1,    Page_2,    Page_3,    Page_4,    Page_5,    Page_6,    Page_7,    Page_8,    Page_9,    Page_10_A, ...

Can Any One Tell Me How Can I Get The Number Of Visible Sections In A Report
To Use As The Upper Bound Of A Loop Of Sections Because With A Worng Number
Of Sections An Error Occured
So If There Is Any Way (Using API,...) Any Way Please Tell Me

I have a report where I want to Sum the qty of sales of a certain product but
I also want to display the Sum of total sales (dollar value).
ProductX_Qty    Total Sales ($)
     120                 $55000

I am currently upgrading a DB from Access 2000 to 2007.
I have been using a Form "Report Date Range" which has the following :
Private Sub Report_Open(Cancel As Integer)
   DoCmd.OpenForm "Report Date Range", , , , , acDialog, "Payments Due"

I Need To Initialize A For Each Loop For The Setions Of The Report Put The
Keyword Sections Isnot Available To Use It Such
For Each Section In Report.Sections
   Statements ....

I tried the carriage return CHR(13) in a textbox but all it does is put a
small box where I want a new line and continues the text on the same line.  
Any suggestions on how to get it working?  I'm running Windows XP if that
means anything.

I generated a report that shows PartNo, Date of Last Shipment, Qty of Last
Shipment.  Because there may be more than one shipment of each PartNo, I
grouped the PartNo and summed the Qty so my output looks like these:
Part   Date   Qty

How would I go about adding a second data series to a chart in Microsoft
Access to be displayed on a dual axis chart?

I have created a delivery table that contains all of the usual fields ,
Pickup, Delivery, Billing, NoPeices, Weight... etc.  The table is updated
with current delivery information daily.  At the end of the week I create a
report grouped on Billing customer that prints an invoice ...