Please advise.
In my accounts database, I would like to produce some reports based on
selection from user. I have created the form with two combo boxes cbxCompany
and cbxProject, and two text boxes txtBeginDate and txtEndDate, to allow user

I have a report with two groups-building and bedrooms. Building comes first
in the group list followed by bedrooms. On the report I only show summary
fields in the footer for bedroom. I would like the report to sort by
building first and then the number of bedrooms. Currently the ...

I set up a "homemade" control array in a report and need to hide / show some
controls like Dat_1, Dat_2 etc. How can I loop through with a type loop.
For i = 1 to 10
"Dat_" & i  = xxxx

I want to create report and want to show only those fields which met the
criteria. All other fileds which don't have that value I am looking for I
don't want them to appear in the reports/query.
Like in my query I have criteria set for Job location, BA, BS, MA. Now I

I want to create some form letters based upon a query.  What is the best way
to accomplish this?   Office Automation or some other way?
TIA
Mike

I am trying to create a report that could be as few as 1
column of data or as many as 10.  Is there any way to do
this - or can there only be a set number of columns
defined on the report?

I have a report for a quote system. The line items are in a subreport which
I have put in the Detail section and made really thin and it grows or shrinks
with the amt of data.
How do I change the report footer property so that it displays at the bottom

I have a report with two groups-building and bedrooms. Building comes first
in the group list followed by bedrooms. On the report I only show summary
fields in the footer for bedroom. I would like the report to sort by
building first and then the number of bedrooms. Currently the ...

I have a report which often has less than 8 records. However I would like to
always print 8 records even when there are less. The extra records making up
the 8 would appear blank but the solid outline around the fields should
still appear. It may be possible that more than 8 records ...

I have a simple report, linked to a equipment table which then links to a
another table servicing. The subform is set to display the service history
link by the equipmentID shows a result for the first equipment item correctly
but none of the others, just does not display a ...

How do I make a TextBox in a report show the number zero instead of a blank.
Thank you beforehand.

I am trying to print out labels, and need to know how many of them I print. I
need to somehow capture the number of labels printed, or send a number to the
print count box so that that many are printed.
Any suggestions are welcome.

Access 2002. Can anyone tell me how to change a subreport's
RecordSource property in VBA code?
Both of the following in the Report_Open event give me an error.
 Main report:   Me.rsub.Report.RecordSource = "Table1"

I want my report sorted by Product code, or Product name, or product weight
...
So I build an combo box, after user selects the sorting field, the reprot
will shows that.

  I've developed a "dynamic" crosstab report (using the method from
Sample97.mdb) where Products vs
ProductionDefects.  I have a table with 30 distinct defects with DefectIDs
numbered from 1 to 30.