Recent content by sheckay

I can tell you this much, that I have never formatted a date into a string.

OK, I wasn't aware of the p trick. I'll test that out and see if it works. Thank you.

Thanks for the reply. I'm looking for something that's convenient for users that are used to the am/pm setup. But military time being what's actually entered for the calculations to work right. The calculations are just a beginning time being subtracted from an end time to give you a total time...

OK, that sounds like something I can figure out. Thank you! Thank you, too, CJ

Hello. This might be a ridiculous question, but I'll ask it anyway. Is it possible to create a drop down for time (with 15 minute intervals) that allows the user to choose from an AM/PM setup, but after choosing the value Access would translate that into military time in the field? Thanks in...

Yeah. It was strange to start having so much trouble with something that was working fine. Especially after entering new criteria that seemed predictable.

You're right. Once I put the "where" info in the date criteria it started working like I was expecting.

Hello. I need to create a total for a field in a query. Simple query. 1 table. But the problem (for me anyway) is that the field that I'm referring to is in the query twice. Once as a group by and another time as a count (to count the total times a value is in that field of the table). So when I...

I wasn't compiling. Just running the code behind it through testing out database functionality.

Thank you!!! That did it!! I had to put the main form info in there. I tried that before even posting this question. But my code was off a little, Thank you!!

Thank you. I tried: =IIf([ispaid],"NOT PAID IN FULL!","") same result

Yes, I did. Sorry. Same result.

=IIf([IsPaid]=0,"NOT PAID!","") too Same result

I've also tried: =IIf([IsPaid]>0,"NOT PAID!","") and =IIf([IsPaid]<0,"NOT PAID!","") same result

Yes/No