Posted by Crumb on 03/02/06 01:18

Many Thanks for the reply, I am one step nearer as this now runs
without errors:)

What I am trying to do is as follows:

I have a table that contains all the phone calls in and out, (Called
and Destination numbers). I am trying to create a asp page that will
search the db for a telephone number (MMColParam) in either called or
destinaition fields but only between two dates (MMColParam1 and 2)

The information you gave me helped me return a result but it returns
all calls and not just the ones between the dates specified.

Do you know what I am doing wrong in the SQL command?

Thanks Again

Ian

[Back to original message]