When I say there is no data I'm saying the form is blank, no data, no text of any kind. The procedure works fine but when the I use my...

Yes I validated the procedure and it works fine it's just it is blank in form format. I know it's hard to figure it out when you can't see it just hoping...

I'm not quite sure how to write the script in visual basic. herre is part of my form.  I wrote

val([afbc]) -val([afoc]) for afsav.  Now I need to pull trhough a stored procedure...

Actually the script above is what I used to pull all the totals. Anything with sav at the end is a total of a particular row. How can I recompute...

everything worked great except I can't pull the totals with a stored procedure. All the data that was inputed is in the table including the totals except for the...

Got everything woking perfectly.  You guys are the bomb!!

 I got everything working but when there is no data I have #error in the totals field. Any ideas? Thanks!

Just tried that just after I send the reply and it worked.  Now I need how to get the totals going down instead of across. like totaling the the totals...

I tried entering the values in access text box "Default value" but no worky.  This is the code I used.  Is there something more to it or am I missing...

The categories are just labels on a form.  The numbers are just values that I'm entering on the form.  I don't think that the way you wrote it will actually...

Well everything worked but I couldn't get the the savings column to total.  Here is the script I wrote:

SELECT     ID, LOBC, LOOC, SUM(LOBC) - SUM(LOOC) AS LOsav, DisBC, SUM(DisBC) -...

Youguys are right.  I'll make form and then a procedure to run the totals.  Thanks!!!

I have 3 columns of data going 3 across for the totals: Example

category                   Brokers cost              our price          total savings

application fee           afbc (1$,200)               afoc ($900)         afsav ($300)

Origin. Fee                ofbc ($1,400)               ofoc ($800)        ...