*Really* dumb MS access question
30 April 2003, 11:52 AM
#1
Scooby Senior
Thread Starter
Join Date: Aug 2002
Location: 52 Festive Road
Posts: 28,311
Likes: 0
Received 0 Likes
on
0 Posts
I never use access, so apologies for the dumbness of this.. 
Created a table and a form just fine
One field on the table and form needs to be the sum of two other fields (field C=field A+ field B).. so I created an event on the form (using before update) to do :-
=[Qualifying]+[Singles]
But it's not doing nuffin - any ideas ??
I still can manually enter a number into the field which is supposed to be a calculation if it helps
Created a table and a form just fine
One field on the table and form needs to be the sum of two other fields (field C=field A+ field B).. so I created an event on the form (using before update) to do :-
=[Qualifying]+[Singles]
But it's not doing nuffin - any ideas ??
I still can manually enter a number into the field which is supposed to be a calculation if it helps
30 April 2003, 12:03 PM
#4
Scooby Regular
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
it would be .text actually but comes up with focus error and havent got time to **** about at the moment
30 April 2003, 12:34 PM
#5
Scooby Regular
Join Date: Jun 2002
Location: Perth, Western Australia
Posts: 1,866
Likes: 0
Received 0 Likes
on
0 Posts
I'm guessing the total is a field of your table?
Assuming it is then you have these 3 text boxes on your form, all bound to their respective fields. Something like this...
To update the Total box you could use a bit of code in the after update event for the single field
Private Sub Singles_AfterUpdate()
Me.Total = Me.Qualifying + Me.Singles
End Sub
This will update the total field.
HTH
Assuming it is then you have these 3 text boxes on your form, all bound to their respective fields. Something like this...
To update the Total box you could use a bit of code in the after update event for the single field
Private Sub Singles_AfterUpdate()
Me.Total = Me.Qualifying + Me.Singles
End Sub
This will update the total field.
HTH
Thread
Thread Starter
Forum
Replies
Last Post
Brzoza
Engine Management and ECU Remapping
1
02 October 2015 05:26 PM