?
Solved

calculated field

Posted on 2007-04-10
4
Medium Priority
?
327 Views
Last Modified: 2010-04-06
got 1 field in adotable called 'working_days' (integer)
inserted into a table calculated field called 'hours' (integer)
how do I make adotable calculate:  'hours'='working_days' / 8

0
Comment
Question by:Vrtnar
  • 2
3 Comments
 
LVL 26

Expert Comment

by:Eddie Shipman
ID: 18882497
In the OnCalcFields event.
0
 
LVL 26

Accepted Solution

by:
Eddie Shipman earned 200 total points
ID: 18882530
procedure TForm1.ADOTable1CalcFields(DataSet: TDataSet);
begin
  ADOTable1Hours.AsInteger := ADOTable1Working_Days.AsInteger div 8;
end;
0
 
LVL 1

Expert Comment

by:Computer101
ID: 21156545
Forced accept.

Computer101
EE Admin
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

578 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