I have a report that fills in Death certificate.  It works great.
However, sometimes we receive the death certificate with some of the
fields already filled in.  How can I design a report that would be able
to leave whatever field already filled in - blank for the purpose of

If someone can steer me into the right direction on this, you would be
helping me out a lot.  Here is my problem…
I have put together this database to record information on two types of
entities – Coordinators and Principle Investigators.

anyone help me how to get SQL code of a table

I created a report that uses
Review#
Month
Case#

I have a report where I would like to have a date in the header, The report
pulls the
data from a query with the following date criteria.
Between DateSerial([Enter Year:],[Enter Month (1-12):],1) And

I have three tables: tblCustomerInfo, tblAssessments, tblOrientation.  i am
able to create a report combining the customer info and assessments as a
customer history report.  however, now i would also like to put the
orientation information in the report as well.  the assessments ...

I have a database that holds 80 records.  In one of the fields, it can either
hold a number 1, 2, 3, 4 or 5, or the text: N/A.
When I go to create a MS Access report, I want it to calculate how many of
each is recorded out of the 80 entries.  e.g. how many 1’s are entered, how

I can change the layout of a field itself in conditional format, but, I
would like to change the layout of another field too, depending on the data
in the "most-important" field.
Can somebody tell me how?

I have just created an application and have ensured that
the User will only see the Switchboard form. The problem I
noticed is that if the User runs a report by clicking on
the command buttons on the switchboard, I don't see any

In the report detail design I have a field: "remarks"
I set this field as "can chrink" and "can grow".
This all works, but, what if the field is empty? It still takes place on the
report printout.

I have a report detailing sales info from specific customers printed out on
3x5 index cards. I have two fields, one with the original purchase and a
second with additional purchases, each separated by a line.
james hatman

the other day james hatman asked:
"I was wondering if in the report, some objects might be able to remain
hidden if the field in the table or report is left null."
ofer wrote:

I want to create a photo directory and would like the layout to be a 8 1\2 X
11 with two columns. That part I can fiugre out.
I'd like it to be like the following in one column.
Any help would be appreciated.

When I create a graph in Access (2000) it brings up different data at the
design view, and when I do the print preview, then I can see my data?
Does anyone know whats up with that?

Our database is on a network drive and the computers with
Access 2002, SP3 can open/modify/create reports. Also the
icon is different, plain square, on the 2003 machines.