Just converted my Access tables to SQL Server tables and wish to continue to
use Access as front end.  Reports are extremely slow so I wrote a Stored
Procedure on Server side.  How do I launch it from the report in Access?

I have created a report in which I'd like a control to print "yes" or "no"
depending on whether a particular field is blank or not.  If say, field 1, is
blank, I'd like the control to print "no".  If it is not blank, I'd like the
control to print "yes".

I'm using the following syntax to show the current weight shipped for a PO,
if there is a contract weight assigned. If there is no contract weight
assigned to the PO, it should be blank.
=IIf(IsNull([Contract Weight])," ",Sum([Weight])/2240 & " G/T")

I have followed along with several people who have posted and have had no
results. I had Office 2k and reports worked fine. I upgraded to Office 2003
and now reports will not work nor can I create one.

Is it possible to link outlook calendar and contact data to an access
database. I wish to store personal info., about people who are running
programs, and the location of the programs, program type and model, dates,
times, and have the info available through outlook or displayed ...

Hi Experts,
I know it's not one of the readily available options but I was wondering if
it is possible to create boxes with rounded corners in Access reports (A2K).
Thanks in advance.

I would like to write a procedure for a report which could provide the
following:
if the footer of the group finishes within the upper half of the page, the
next group should start on the same page; if the footer of the group finishes

I have a DB created in Access 2000 (SP3) and moved to a PC with Access 2002
(SP3). All reports in the DB open in Preview mode. One report when opened on
the Access 2002 system immediately closes Access with no message but still
works OK on the Access 2000 system. Attempting to ...

I'm generating one report from one query...I am confused how to write sql
for query..
I have two table one is Customer (Id,Name,Country)
Another table is CustomerPwd (Id,CustomerId,PwdType,Password)

One user pulling reports got this message:  Microsoft jet database engine
stopped the process because you and another user are attempting to change the
same data at the same time.  Any advise?

**Using Windows 2K with Office XP**
I am pulling reports from read-only tables.  Report shows a breakdown of
accounts created in individual branches by regional office, district office
and branch.  My task is to acquire a random sampling of files from each

I have a query that have some sum field that I want to display in the Report,
can ths be done?
The sql works now perfectly , but can the sum of hours is in blank .
Employee 1234   Pay Perio ending 12122004 (2 weeks)

Hi guys. This might be a pretty basic question, but how do
you make the chart bigger in Access 97 instead of the
small little chart the wizard makes for you? I'd like it
to be the size of a 8.5 x 11 inch peice of paper.

I recently reinstalled Office 2003 under Windows XP Professional. Since then
I have been unable to open Access reports I have used for years or to create
new reports.
Please help. Both Office and Windows XP are fully up to date.

I will be having 10s (if not hundreds) of clients and want to include the
client name address, etc. in the header of reports.  Is there a way to store
the client information in a table and have the report header pull the
appropriate information? For example, the version that is ...