e-mail single reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi guyz,
i have 2 questions if some1 could help me out, ive got a few text
boxes " Submitted 1, Submitted 2, submitted 3 ect which are currency defined,
then i've got Total Submitted - when i enter the amount into Submitted
1,Submitted 2, Submitted 3 it comes up in the Total Submitted box but if i
was to leave the Submitted 3 box empty the total does not appear any help
about this would be fantastic.

My other question is i want to send a single report by email, i would like
filter them by a field called "ReportNumber" could anyone PLEASE HELP ME WITH
THIS
 
Matthew,

It looks like the code is truing to add three number and display the sum in
the "Total Submitted" field.
So, you should check before adding the 3 values that each one is a valid
numerical value.
(In your case, if it is blank, you should convert it to zero)

Andrei.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Frontpage 2000 - Going to a new page from a value in a drop-down box 0
Excel How do you export e-mail content into an excel spreadsheet 1
pulling reports by date 3
Trying to get filtered Report based on form combo box 1
Query to Look-up Value in place of SNo 3
Query Criteria 1
count total month per year 2
Criteria/CountIf and Pivot Table 3

Back
Top