Search results

I think the second one answers my question. But basically what I'm trying to is have the old form fill out the new table and the old table at the same time. Since the new table I'm putting in has some of the same info as the old one, I don't want to be entering it twice. Say for example my old...

I want to add a new table on my database but I want to use the form I already have to fill in the new table I'm adding. How do I do this? The new table I'm adding is a related table to my origianl table I have. Please help me!!!

yes, all the fields are actually on my report. That's the reason why I dont understand why it's not summing it up. Thanks again for your help!

Is there a way to just do this on my query instead of the report? Thanks again!

I tried both of them and both times it is still asking me for a parameter value everytime I try to get out of design view.

I double and tripled check the spelling and yes all 3 are part of my query.

I'm trying to sum up 3 differnt fields in my report. I used the expression =[field name 1]+[field name 2]+[field name 3] but it's not working. whenever I try to get out of the design view it keeps asking me for a value for each field on my expression. What am I doing wrong??? PLEASE HELP ME...

All I actually want is to have a counter that updates when ever I delete a line. Say for example I have lines 1 to 1000 and I deleted line 501, I want line 502 to be 501 since I deleted the original line 501. Is this actually possible in Access?

Can anyone help me please?? I'm trying to put a auto counter on my table data. I used the auto number type and it works perfectly not til I deleted one of the lines... I lost the number sequencing cause I deleted one of the line. Is there a way for access to auto update my table so i wont lose...