Add time in access using 2 fields

[twinnyfo]

Have you tried stripping the query of all extraneous tables, forms and what-nots? Then try recreating what I demonstrated above. See if it is something related to the complexity first. If it works, then we redirect our efforts toward decomplexifying things......

[DJRhino1175]

Here is a screen shot of my query.

[twinnyfo]

Impossible to see it that small. I can only presume it is similar to the one I provided. Can you post a list of returned values from your query? I'll se if that has anything to do with it.

[DJRhino1175]

Ok I just made a query based off of the query I sent as a screenshot and the formula works perfectly, except I don't need it in seconds, but that should be just changing the format.

[twinnyfo]

So....... I guess it worked? I must be sharing some of my gremlins over the internet!

[DJRhino1175]

Yeah its weird that I just needed to make a query of a query to get it to work. So now if I switch my forms record source to this new query I'm hoping everything will still work.

[DJRhino1175]

ok, son now I get a #error on this field if some of the data is missing, I'm assuming I need a Nz() the there somewhere. Would I put this in the front of the formula?

[twinnyfo]

It could also be a divide by zero error. Math functions do not like to calculate null values, so an Nz([Value], 0) should alleviate those problems, outside of div/0 errors.

[DJRhino1175]

EndTimeOfProduction: DateAdd("n",[ProductionTime],[StartTimeOfProduction])

Where exactly would I put Nz(Value], o

[DJRhino1175]

Sorry I figured it out after I scratched my head and tried a few things. The only thing is I cannot get the seconds to disappear. I have the format set for medium time and its showing, for example 00:00:00 am

[DJRhino1175]

I also noticed that when it goes past midnight that it adds a date in front of it, is there away to make this not show?

[twinnyfo]

Simple:

EndTimeOfProduction: Format(DateAdd("n",[ProductionTime],[StartTimeOfProduction]),"Medium Time")

[DJRhino1175]

Perfect. Thank you so much. This is what the final Code ended up looking like.

EndTimeOfProduction: Format(Nz(DateAdd("n",Nz([ProductionTime]),[StartTimeOfProduction])),"Medium Time")

[twinnyfo]

Glad I could hepp. Sorry it took so long to resolve this issue.