Search results

Thank you for your advice. I'll keep this in mind going forward.

What's wrong with storing these values in separate fields?

Yep! That was it.

I'm sorry - I thought I had mentioned I tried that. My mistake. Yes, normally that would work. However, I just realized that my query is of a qryDef and I bet that's the problem. Thanks.

See attached query. Is there anyway to not show 0 QOH results? Thanks!

theDBguy - Thanks for your help. Not sure what I did differently, but I'm now able to do CF on string values with no issue. Sometimes, if I make too many changes without compacting, my changes don't always happen. Maybe that's the case or maybe I phrased the condition differently. Again...

Thanks for your help. Yes, I'm able to do CF in I stick with integers (which represent minutes.) Unfortunately, the user wants to see the result in "hh:mm" format.

I have an integer, e.g. 240. I convert it to a variant in hh:mm format, e.g," 4:00". I then save this in a field in my table which is formatted as a string. My report (based on my table) displays the value "4:00" in the report field. So far, so good. I was hoping to do some conditional...

I'm trying to create a function that lets users to scan a document and save it to a folder. I start with "Dim scanDiag As New WIA.CommonDialog" However, it throws a ""User-defined type not defined" error. I am referencing the Microsoft Office 16.0 Object Library. Thanks for your help. If...