I hope you can help me.
I have inherited quite a large access database upon which I now need to do
some more work. The database is based upon a questionnaire administered to
2500 students. One part of the questionnaire examined their supplement

I am trying to replace our debit memo form with access 2000.  I have 2
tables (1 -- cust and other info, 2 -- items being returned -- 1 to many
rel).  I have the form and report done.  The report is generated by a query.
At the bottom of the report is a page designation (i.e., 1 ...

When there is no data in the subreport the main report calling an unbound
text box displays #Error.  I would like for the #Error to say “No Data”
instead.
Background Information:

I was just wondering how would I Calculate the difference
between two seperate dates, and after I have done so I
need that calculated date to be displayed in another
field.

I have seen on some databases, when I am in the Reports screen at the top
there are some icons. Printer, email (has little envelope with paperclip on)
and Export Icon ( giving me the option of export to excel or snapshot viewer)
how can I get these icons on my own database ...

I want to include todays date on my report. =Date() only shows 15/11/04.
Is there any way I can get it to show 15 November 2004 instead?
Thanks.

I'm preparing "MyReport" in Access 2000, to list about a thousand records
sorted in a two-level grouping.  There are seven categories in the outer
group and eight categories in the inner group.   The report is based on
"MyQuery" and works well.

I have saved jpegs as an OLE linked object and they don't show up in the
forms or reports. The file name is the only thing that shows. How can I get
these photos to show up on the forms and reports?

How do I set access to figure differant pricing depending on cost. For
example I have a price list and if the part cost me $0.01-$2.00 I'd like to
times by 4 if it cost $2.01-$5.00 I'd like to times by 3.5 and so on, please
help,  I am new at this and on a dead line.--

I'm using the label wizard to create labels, which is pulling information
from a combo box field in a table. The Contact ID # is showing the Contact
ID# as opposed to the Contact Name from the table the combo box is based on.
How can I get the Contact Name to show on the labels?

I have read with interest much of the discussion regarding subReports and
Totals etc.
I understand how to not print a subreport on a report when the subreport has
no data but when I try to calculate the Grand Total of all subReports at the

I have a Summary report that is grouped based on a date span. I want to add
a deposits made from the deposits subreport using the same date span. How
can this be done,or can it?

I have a sub form containing address data.
The form has been modified to include a VBA makeaddress text box.
When the subform is added into a report the basic data is shown along with
the outline of the VBA text boxBUT not data is shown in the VBA box.

Please can someone help.
I have a report, based on a query, in which for each record I want to
print a value in Field A only if Field B contains a specific value.
The fields are text fields and although Field A will always contain a

how do I put line numbers on a page when the number of lines vary? can I use
a sum text box with conditional formating??