@john-2,

I will give it a try, not going to lie I am not an SQL pro at all where would I put this statement? What do...

Perfect, I was missing the DATEPART, I was using DateTime that was my issue

thanks

thanks @steve-2 Jones, that worked perfectly... I am new to this I am sure you can tell, I swore I tried what you did for me but I...

I complete get it is hard to troubleshoot even when the op (me) does not know what the query does.

Little more background when the user opens up access, access is...

Not going to lie, I am not 100% how it works it appears the form is using this query as a row source

here is an example of one that is...

I posted my whole sql query sorry if I didn't post the correct thing

the data I posted is the output I get when I run the query

I will try the...

qta-subbld4-swt1-ups1qta-sub-bldg4-swt1-ups1.domain<-should show

qta-lr-china-hssp-ups1qta-china-hssp-ups1.domain<-should show

sha-cab67-ups1.domainsha-cab67-ups1.domain<-should NOT how, but does

sha-cab78-ups1.domainsha-cab78-ups1.domain<-should NOT how, but does

sha-cab4009-pdu1.doaminsha-cab4009-ups1.domain<-should show

There you go

Thanks