Do you ever get to any of the dart tournaments over there?

dartcoach

I have done in the past! why do you ask? i much prefer Soccer!

UNBELIEVABLE, it worked on the first query i used it on. I have just created another and put the expression you gave me in, then put <=17 in the criteria and it says data type mismatch!!!! I just cant win!!!

switch equals sign and the less than sign around.

I play darts over here. I've played against all the big guys from across the pond.

dartcoach

Have you played against Phil 'The Power' Taylor?????

It says invalid syntax for the reverse!!!!

Yes, and Peter Manley, Peter Evison, Dennis Priestly. In fact, Peter Manley, Peter Evison and I had a great time on the town in Las Vegas one year! I haven't seen them in years, but they are great guys.

If I could find a job over there, I'd be there in a heartbeat!

dartcoach

switch the equals sign and the less than sign back. what's the difference in this query than the other?

dartcoach

There is no difference apart from the last query, there was only, first name: last name: Award. On this one, it is a full contacts list and i have added the syntax you sent me!!!! I cant believe you are a prof darts player. Cool. I bet Vegas was a good laugh, obv plenty of Beer drank!!!!

can you cut and paste your sql? I think there's probably no problem with your award. it's probably something else.

As for the beer - you bet!!

dartcoach

dartcoach