database for a machine shop

[thelostcircuit]

ok im making a database for a tumble prosses at work

first problem:
i have a yes/no field in a table "pull ontime"
witch i want to be controled by "pull actual" witch it a time filled in with the now() comand trigered by a button in a form i want to make the "pull ontime" field read no if the time is over 1hr over a value "pull" and read yes if under this 1hr

second problem:
there are machines that are loaded with parts i want to make it so when they enter the part # and the s/o # and stuff they will hit a loaded buton witch i want to make it put the Now() time in the "Loaded" them based on the operation witch has 2 cycles witch depending on the operation the first cycle could be 2 hrs and the 2nd could be 1.5 hrs i want it to based on the operation selected set the time that the oporator has to change the cycle "rinse" and "pull"

 

[Rich]

You don't need a boolean field in the table to display whether the pull is on time or not, an unbound calculated control will display this for you

 

[thelostcircuit]

ok first ov all i dont know that a boolean field is and second i dont know how to make a calculated control so i guess i better start reading a good book on access

any pointers on what books are good