Can anyone tell me the best way to put a selection criteria on a report?
I have a grouped report returning all records on the table with a page break
after each group to give me an Invoice per page.
I have a form that the user keys data into, I have added a button to preview

Looking for suggestions on best way to generate a report that displays a
record as it was originally listed in the table and the record after the user
makes a change.  I have a form which displays the records.  My thought is to
lock the records until the user marks a checkbox ...

How to I sum the non-numeric fields. I do a count on the non-numeric field at
the footer level, now I want the total at the end of the report.
TIA

We are using Sharepoint Portal server which is running on a SQL server
backend to track client trouble tickets.  We have a report written in access
that pulls the data from the SQL server table and displays the data from
different fields.  Everything is working the way we want ...

Don't know how to set criteria on query to restrict report to yes/no boxes
ticked on main data.  Tried yes, not null, true but no data not restricted or
get none.

I have a crosstab query that runs fine and I get the information I need but...
when I try to run a report from it I get the error "The Microsoft Jet
database engine does not recognize 'Alldoctotals2004.refdoctype' as a valid
field name or expression.

I can successfully turn resizing off and on in the RTF2 sample database
by removing and reinserting the resizing code:
Private Sub Detail1_Format(Cancel As Integer, FormatCount As Integer)
Dim Height As Integer

I'm only a wizard prodder, but I can paste code.
First I tried using the unbound object frame to 'import' a single row of
vertical text columns from Excel97.  My problem is that I can never get the
column widths set so as to have all the 'labels' line up correctly for the

I have a main  report and a sub report. Main report has 3 parameters and
the main report works fine. Now I want to add a sub report to it. The sub
report should have the same three parameters as the Main report has.
The important factor is HOW I CAN DO THIS THROUGH CODE? I know, ...

Sorry if this is very basic:
I have a table of names and contact details (address, phone no, e-mail) and
I want to print it out in a report, in as compact a form as possible.
Many of the entries in the table have blank fields, some only have a name

I have a simple invoice report that includes a company name header with the
name and billing info and the have the detail with each date and description
of billing.  Then all I have is a company footer with the totals and page
and report footers for the page number and pay to ...

I have an invoice report I run every month and the description for the
billing is a fixed size regardless of how much is typed in the description,
so I either get a lot of blank space between records in the report or it
gets cut off.  Is there a way to have it autoformat the ...

I am a doctor and I am designing a software for my hospital billing. Now
there are various fields like
1. bed charges
2.  nursing

In a report I'm creating I have created a subreport.  The subreport is
located in the first level grouping of the main report and is linked via
parent-child relationship.  The report displays and the data is linked
properly; however, the contents of the subreport can extend past ...

I've been struggling with this error for a while now...hope someone out there
can help.
I have a form where the user would enter the parameters for a crosstab
query.  The crosstab query works fine, and when I open the form and enter