Search results for query: *

Hi, Can somebody tell me how to validate a field with a formula that includes the MOD operator? I tried to validate on the table but later read that the MOD operator is not accepted. Thanks for your help, Luis

I have a field that has the following format wxy-z (all of which are numbers). I need that after the user inputs data into it this condition is met: z= MOD ((w*2+x*3+y*4)/11). If this condition is not met an error message box pops up. I couldn't validate this field within the field properties...

Thanks for your response. I would have one ST and FT for each day but they'll vary for each person. Also, where do I store the info. as days go by? If I build a table with the info. you told me I'll be overwriting it every day. I know this is very basic but I need to know it. Thanks again

I am a newy so please bear with me. I am building a database to capture how many hours each employee works. Each day, the user will have to input the start time (ST) and the finish time (FT) and the program would calculate how many hours each person worked. My questions is: What type of table do...