?
Solved

calculated field

Posted on 2007-04-10
4
Medium Priority
?
322 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 26

Expert Comment

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

Accepted Solution

by:
EddieShipman 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

765 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