Search results

Hello All, I have had a request from mgmt and I don't even know if it is possible. We have the following objects in our database Table-Non Production ([Work Date], [Department], [Task], [Quantity]) Table-Tasks ([Task], [Prod or non]) Form-Non Production Entry Form ([Work Date], [Department]...

I have been reading through similar problems and can't figure out how to make any of the solutions work for me. I have a form (Production Form) with the following fields: [DateReceived] (the date the job request is received) [DutyType] (Combo box that includes two columns, in the first column...

Hello all, In Access 2010, I have a form called "Production" and a subform called "PWD" that only gets called for special forms in "Production." Before I put the forms in a Navigation Form, I had a field in "PWD" with a default value from an auto number in the "Production" form. In the...

Hello, I am making a report that takes total seconds that it takes to do something and converts it to hh:nn:ss. In a different report I use =Format(Int(Sum([IT Total Seconds])/3600),"00") & ":" & Format(Int((Sum([IT Total Seconds])-(Int(Sum([IT Total Seconds])/3600)*3600))/60),"00") & ":" &...

Hello, I have a database that collects data on the length of calls in hh:nn:ss format. I need to be able to add these together in different queries giving me monthly and ytd totals but Access doesn't go past 24 hours. Does anyone know how I can get accurate totals? gg

I'm not a programmer, but have had the opportunity to set up a couple of Access dbs over the years. Now I am on a project where I am putting together an elaborate database for a business, so I will have many questions. Thanks for this resource. gg.