What is normalize
I have seen you use it alot and I think that it may help me with my queries.
would you expand on what you mean?
Thank you so much

This is driving me crazy.
When I build a report, if it is not set up in the default  letter size /
portrait / 1" margins, I find that in  the mde files I produce, previewing  
reports will default back to the default settings. If you go into page setup,

I have a 2 forms that are used in a form/subform relationship.  I would like to put a button on the subform to print a report for only that one particular record.  Can you offer some assistance
Thanks

I have used the instructions in the help file to create a report that uses a
dialog box to prompt the user for a parameter.
Everything works fine, except I would like all records to be displayed in
the report if the user doesn't select a value from the list box.  Presently

I am creating a mailing application that is replacing a
system that someone has in word.  I have a report that is
a letter that gets sent out to people.  I also a report
that creates mailing labels.  The problem is that the

I have a very detailed report with two sub-reports embedded in it.  When this
report is run several times in a row (why the eu does this?) the system
crashes and gives the error
"MS ACCESS HAS ENCOUNTERED A PROBLEM AND NEEDS TO CLOSE. WE ARE SORRY FOR

I have a report that has a group footer.  The totals and test boxes show up
at the end of the group but none of the labels show.  If I add a label to
the footer it does not show either. Am I doing something wrong

can anyone help me with referencial integrity.

I created a report in Access and tried to include the date
at the bottom of the report. I added a textbox with the
control source of =Now() (and the format was medium date).
The control box is in the Page Footer section of the form.

At the moment I use a excel file to report some data. From now I want to
start using a access database, however I need to keep the same format that I
have in Excel. Is there any way of importing the excel file to produce the
report ? Or do I need to draw everything ?

I am entering the following if statement:
=IIf(Sum([Text98])-Sum([Text99])>0,Sum([Text98])-Sum([Text99]),"")
Basically, I have text100 text box on my report that is the following formula:
=Val([Text98]-[Text99])

I have several textboxes on a report in Access 2000. Upon running the
report, I'd like populate each textbox with a different VBA variable from an
Access module. (not a form or report module)
Does anyone have any ideas?

The company names and street names overextend the label and I would like to
wrap the text so that it will use the next line instead of being cut off. PLZ
Help!

I would like to have field print every value except one.  If that value is in
the field I would like for the field to be blank.  Is there any way to do
that.

How do I exclude records with a particular value in a field when running a
report.
For example: I have a field ("Relationship") that has three possible values:
("Other", "Core", "Advisory").