Thanks. I ended up writing a little funtion that did this for me. If anyone wants to use this feel free.

// Date Format Function

evdate = rs("press_date")

On Error Resume Next

evdate...

You may want to read this article. I don't know if this will help but its worth reading. I'm not an expert i'm just learning myself so here you go.

http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp

...

Thanks mromm for your help. I'll try that.

Thanks Antares686. I'm going to bookmark this page. I'm reading up on it now. Very good information. Thanks allot it worked.

Well guys I got it working by writing a funcion that replaces the two dates entered into the two fileds and formats them to look like this date1 - date2.....

Only drawback to that is i want to pre-plan events. So if an event is 3 months from now i want to be able to add that and it lists...

Thanks phil i really appreciate your knowledge. I will make these changes and remember this for the future.

thanks again.

Here are the answers to your questions...

1. The datatypes were datatime, i changed them to varchar, then it worked.

2. Yes there are other fields in the table

3. They are populated...

Hey Tad thanks man. I'm sorry if it was a stupid question. I'm new to SQL 2000 just learning. You've helped me out tremendously today. Thanks again.

Thanks Scorpian 66. I appreciate your help allot. I'll look for that article.

Thanks Tad that worked.

I am currently doing it like this

SELECT *

FROM Members

WHERE (EMAIL = NULL)

Well i am...

i would like to use SQL Server security.

Thanks i changed this to the Account Admin and it now works.