Search results

I will give the SOP table another look maybe that is what you mean

Yes the database has other tables that keep track of the training courses and other info. I am only mentioning the Main table here because to me it makes the most sense to keep track of the Time to Complete except for the fact that it only holds current training. I actually have everything...

But how do I keep track of previous trainings that are not included in the Main Table?

I am able to create the output I need using the Main Table,the only issue is that that records only the current training and does not keep track of previously completed classes. It is this past history that is the problem. I know I need a separate table but a having problems addition the...

Thank you - I will be working on this but will be out of the country for a couple of weeks so won't be able to get back to until July but I would really appreciate your help!

Ok so trying to back up and look at this differently. Currently the database stores the Employee ID, SOP Number, SOP Version and Date Completed in the Main Table. This only stores the most current training for any SOP done by each Employee. So employees many times have to repeat training each...

The date completed is the actual date completed (duh) The completion time not the same in that it keeps track of the time it took to complete the training, such as 20 minutes. I know the naming is screwy but in part that is what i have to work with because this is an extensive database and I...

It is bound to another table. As far as the query, I used Access to create it and that is what came up. And yes I am sure my methodology is wrong as I am up to my neck in confusion at this point!

Would this cause it to not show up in the query? and I can't figure out how to fix it (again please forgive my ignorance) Thanks

Hopefully this will help, when I tried to run the query I got this error:

I am creating an append query based on a form. I have results in 3 of the fields but for DateCompleted and Completion Time the fields are blank when I view the query. I am totally stumped as to why this is happening. Has anyone had this experience and can you point me to what might be causing...

Thanks again everyone - will post back when I work on this again.

Yes I understand that - that is why this is so strange to me. Yes I will be looking into this next time I am on that computer. Thanks for your help! I have a feeling it is one of the other lines of the code causing the problem and the message (as often it seems) is not really telling the...

That is what I have - When I say similar - there are additional fields in this code but the first line is exactly the same (DateCompleted) and there are no issues with it for that table. The fields in the tables for DateCompleted are set up exactly the same. I am not on that computer right...

That is what I have - so I am confused. What should it be? I don't understand why this does not work when I does when I use it to add to a different table with the same set up

Can anyone please tell me where my syntax error is in this code? The error message states syntax error in date in query expression but I am using a similar code elsewhere and I don't get this error. I am sure it is something simple that I am missing - so any assistance as always greatly...

Thank you - I will be working on this again Wednesday and will look at this closely! Really appreciate the help

I am not on the system right now but will check this to be sure - I think decimal is left blank..but I could be wrong

The value us only 40 so I doubt that is the problem... thanks for the explanation of display purposes vs storage!

That is what I am thinking of doing - thank you