Search results

Thank You, Jon K I will work with it this way, It will need some babying but I am willing to do that for now...it isnt something that really makes a big problem... Many Thanks, again!!!!! Noreene

Jon K Just one more question concerning the query for calculating time between rows... If a picker logs in say at 4:30, logs out at 9:30 then logs back into function at 10:15 and logs out at 14:00....how do I tell the query to pick up the correct logout times in the blanks...right now it pulls...

Hello, Jon K I know you will be glad to hear this..IT IS WORKING!!!!!! I had to make a query from tbllog with a field that added timeloggedout + date and so far that seems to work...I never was able to format the field in the table to make it work...dont know why... But, many many many...

Jon K Yours looked great, but as soon as I imported my original table tbllog to the db I unzipped from you, I still got that crazy number when I logged someone out in tbllog....Do you have any suggestion? I realize yours works fine, but what could make my number so crazy? I am attaching a...

Jon K You are probably tired of me...I couldnt seem to get it right with new query...It has something to do with my format because yours works.... The problem is when I manually log someone out of the tbllog....I can run the query (I entered a new field to calculate time) and when I hover my...

Jon K I have just one more question....Why is it when I pull in my logouttime from another table, that the calculation gives me a crazy number like -5447212272 or when I format it for short time, it tries to give me 21 hours when starttime is 8:31 am and timeloggedout is 11:30 am? I cant seem...

I am so excited to see this query working!!!! Although I don't understand the function, it does what I need for it to do..and I am greatly relieved... Thanks to you, JonK for all your help...and to others that have been so ready to answer... Noreene PS This is the best forum I have ever...

First of all I would like to thank both dcx693 and Jon K for all your help. I am attaching a scaled down version of my db for you to look at if you have a chance...What I am needing is for the first record to show starttime,and the next starttime should be the finishtime on first...

Thanks, That makes sense in my mind, but I just cant get it together on the grid...could i use something like TimeElasped from previous row? (or something like that!!!)..Or maybe if you explain how to reference the row above...because the autonumber is not in order by pickerid...several...

I really like the new look!!! I am beginning to realize that this is the DB from hell!!! I am trying to create a query that will calculate time between rows...For instance, my table has pickerid and time they pick up an order (which is time stamped) and I also have a start time for the day...

Me.tblexpectedhours = DLookup("tblexpectedhours", "tbllogcomplete", "tblpickerid = " & Me.tblPickerid) Okay, so let me see if I understand what this code is saying; I want it to look at expectedhours field on the form and then lookup that same field in table logcomplete, where the pickerid in...

Mile-O-Phile Thanks for the quick answer!! It is giving me an error that says data type mismatch in criteria expression.. Could you tell me what each component of the code means so maybe I can figure out the problem? Thanks again, Noreene

I have a form that fills in a table and I need to ask what code would I use for the on close event of the form so it will fill in the same expectedhours for that picker on this date() in the table. Example: If picker id #327 had 7.5 expectedhours on first entry for date(), then the...

Rich, YOU ARE SO SMART!!! Thanks alot! Noreene

Thanks Rich, I have tried that plus every other way I can think of... This is what I end up with: Regularmin=65 wavemin = 284 =([regularmin]+[wavemin]) and it gives me 65284 I have tried every way I can think of and it will only combine them not add them. Thanks, NOreene

I am trying to add a number in two fields on my report in detail section in an unbound textbox called SumMin. One number (wavemin) is 65 the other field (regularmin) is 284. I cannot get it to sum up to 349...it always gives me 65284.....What am I doing wrong? Everyway I try it always ends...

Thanks Mike for your reply And I do think you are right..I need to re-think what I want to do... Noreene

I have searched and not found exactly what I need, so here is my question...in fact, I have worked on this for an entire day before I came here for help. I have 2 efficiencies calculated in my report...the efficiencies are for regular and wave I need to average the 2 efficiencies to get an...

Thanks Rich, I will give it a try ColinEssex: I dont have a way to keep employees from looking up other efficiencies....if they know the employees' id # they can look up someone elses... Any suggestions?

My form has a command button that employees can click to get current efficiency....The command button runs a query and opens a form that shows their name and efficiency with a command button to go back to original form. However, if they put in the wrong id # or hit a + sign or something...