Solved

calculated field in a table?

Posted on 2016-10-14
3
28 Views
Last Modified: 2016-10-14
Is this possible?

thank you
0
Comment
Question by:pdvsa
3 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 41843396
Yes, but refrain from using this "feature". It will only cause trouble sooner or later.

Instead, create a straight select query using the table as source and add calculated columns/fields as needed. Then use this query for your further processing.

/gustav
0
 
LVL 18

Expert Comment

by:Pawan Kumar Khowal
ID: 41843397
Can you explain more , table structure , what calculated field you want to add. Are you using MS Access DB? Version?

Yes it is possible. But you can get calculated data at run time. Why to add to the DB?
0
 

Author Closing Comment

by:pdvsa
ID: 41843585
Thank you Gustav...
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now