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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
formulas

ResolvedVersion 2007

John has attended:
Access Introduction course

Formulas

When creating fields, how do you insert formulas using information in another field?

RE: Formulas

Hi John,

Thank you for your question and welcome to the forum.

As far as I am concerned you cannot set the default value of a new field in a table to display the contents of another field.

However, if you create a form based on the table, you can insert a text box and set the control source to be a field from one of the Tables in your database.

I hope this answers your question.

Regards

Simon

Tue 9 Jun 2009: Automatically marked as resolved.

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.