Newbie needs help!

  • Thread starter Thread starter Avizandum
  • Start date Start date
A

Avizandum

Sorry for my ignorance folks but here goes!


I have set up a table in design view like this....................

FIELD NAME DATA TYPE DESCRIPTION
* Job Number Number Unique identifier for each
job
Labour Currency Cost estimated for
Labour
Material Currency Cost estimated for
Material
Total ???????? Total Allowed for
Job


I am trying to get the sum of Labour and Material to be the default value
for the total ( indicated by ????? )
I have tried setting it to currency with the default value =[Labour] +
[Material] but no good as my newbie status will attest.

Is it possible to set the value in total as required whilst in design view.

As I get better I would then like to set up a table showing how much was
actually spent with the difference in totals being the default value in
another table showing the end result of the job.


Any help would be greatly appreciated.


TIA


T
 
Second try!
/////////////////

Sorry for my ignorance folks but here goes!


I have set up a table in design view like this....................

FIELD NAME DATA TYPE DESCRIPTION
* Job Number Number Unique ID
Labour Currency Cost estimated
Material Currency Cost estimated
Total ???????? Total Allowed

I am trying to get the sum of Labour and Material to be the default value
for the total ( indicated by ????? )
I have tried setting it to currency with the default value =[Labour] +
[Material] but no good as my newbie status will attest.

Is it possible to set the value in total as required whilst in design view.

As I get better I would then like to set up a table showing how much was
actually spent with the difference in totals being the default value in
another table showing the end result of the job.


Any help would be greatly appreciated.


TIA
T

ps * = Primary Key
 
FORM VIEW: Create a textbox. Go to its properties. On the DATA tab you want CONTROL SOURCE; key in this information or its close facsimilie: =[Labour] + [Materials]. This will be a calculated field. If you want table, while in DESIGN VIEW, go to the GENERAL tab and in the Default Value key in the value, such as: =15.00.
 
Back
Top