Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

subtracting field value another

Forum home » Delegate support and help forum » Microsoft Access Training and help » Subtracting on field value from another

Subtracting on field value from another

ResolvedVersion 2003

Lee has attended:
Excel Advanced course
Access Introduction course
Access Intermediate course

Subtracting on field value from another

I would like to deduct the value of one field from another in a query. The information is in two different tables within the query.
How do I do this???

Regards,

RE: Subtracting on field value from another

Hi Ross,

Thank you for your question.

The two tables should be linked first.

Create a query and insert the appropriate fields needed for the new calculation. In the next available blank field type the name of the new calculated field followed by a colon to show that is the end of the field name:

e.g. LengthOfService:[HireDate]-[FinishDate]

After you have type the formula in make sure you click the Show checkbox.

I hope this answers your question.

Regards

Simon

Tue 29 Sep 2009: Automatically marked as resolved.

 

Training courses

98.7 % recommend us

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Please browse our web site to find out more about
2003 access micorosft training and other training courses.

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown


View all Access hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.1 secs.