I have a report based on a query that uses 2 tables.  Table 1 has 2 fields:
an autonumber field that is the primary key and "field1" that is a list of
accounts.  Table 2 has a field that is based on the "field1" of Table 1 as a
lookup field.  The entire query uses Table 2 and ...

I have a query driven report the has a field called "ClockDate" and a
field called "UserID", I want to attach a Sub-Report which has a field
called "date" and a field called "UserID". I want to link the Subform
records to the main form by "UserID" to "UserID" and "ClockDate" to

Here is what I have:
1.  Form in datasheet view that I use to filter records and hide /
unhide columns.  Has button on custom toolbar to open report.
2.  Report that opens from datasheet form above that show my fiiltered

I have created a report that runs from a datasheet form.  I can hide
and unhide the columns in my form and then generate report where it
then hides or unhides my columns the same as my form.  But I don't
know how to make my columns that I have made invisible move to the

Hello I have a report that has a number or record, this record hold a number
of line of data, example:
job 1 my house
builder xxxxx

Typically when I create a standard query, I insert non-existant fields
(variables) for user input criteria at the time of running the query. For
example [Input Start Date mm/dd/yyyy]. This would allow the user to run the
query using a START DATE Criteria.

I am new at designing reports--I'm used to importing data from Access into
SAS for data analysis, but now I need to design some reports in Access for
end users to run with their data.  Can you design reports (I am guessing
using queries as the record source) that look similar to ...

Afternoon'
I have a report that has three stacked txt fields in the Detail section, all
with the 'can grow' attribute set to 'yes'. These fields are each on a line
by themselves. I have the following code on the 'On Print' event for the

Hi. I have a report and in that report I have a group header.
Is it possible to force the the report to start in a new page whenever the
group header change?
Regards,

When printing a report with multiple copies, is there anything like a
"CopyNumber" property that could be used to identify the individual copies?
I suppose the alternative is to have a Label or TextBox and paste the
description in there.

In a report I have Report  Header; Page Header; CustomerID Header; Detail;
CustomerID Footer ; Page Footer and Report Footer.  In CustomerID Footer  I m
doing the sum( RvTotal) which will just add the RV and bring the total of
each customers receipts.  

Hello togehter,
i have a strange problem with the RTF2 ActiveX Control.
The control is several on the report.
Arbitrary the control moves the control the characters apart and

I am having some problems using Date Range on Crosstab Query to create
a Reports.
I specify the 'StartDate' & 'EndDate' for the Date Range in the Query
Parameters Table. It prompt me for the Start & End Date. It works fine

i just would like to show my table as a chart, but when I build up the chart
Access 2007 shows me some totally different data!?
I also tried some other and pretty simple tables but the result of the chart
data is always the same with some "East, West, Nord...0-100" data.

I have a report that has System Description....if a user is assigned to the
system then the FullName should show up however if the FullName is blank then
I want the LocationDescription to show up...can this be done if so how?
Thanks