Simple Calculations Within a Table

[SamDemon]

Could someone please help please as I am very new to completing calculations within Access (would be fine if it was Excel!!!).

Within my table 'tbl Group Bookings'I have a field called 'Total Fare' this should automatically calculate from the following:-

[Single Net] + [Single Tax].

I'm really stuck on how to do this, so any help will be much appreciated!!! Hopefully if i can grasp the concept of this easy one I should be able to do the really nice hard ones later!!!

Thanks in advance!!!!

Sam

It's just common sense, shame sense isn't common!

 

[lespaul]

Why are you wanting to store a calculated field in the table? breaks 3NF.

Read 'The Fundamentals of Relational Database Design'

When ever you need the total fare:

SELECT [Single Net] + [Single Tax] As [Total Fare] From [tbl Group Bookings]


I would also recommend that you remove the spaces in your field names. you are going to get real tired of putting the [ ]!!

Leslie