Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 23rd, 2005, 07:08 PM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

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

dartcoach

 
Old February 23rd, 2005, 07:16 PM
Authorized User
 
Join Date: Feb 2005
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old February 23rd, 2005, 07:18 PM
Authorized User
 
Join Date: Feb 2005
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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!!!

 
Old February 23rd, 2005, 07:21 PM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

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

 
Old February 23rd, 2005, 07:23 PM
Authorized User
 
Join Date: Feb 2005
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old February 23rd, 2005, 07:25 PM
Authorized User
 
Join Date: Feb 2005
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It says invalid syntax for the reverse!!!!

 
Old February 23rd, 2005, 07:25 PM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

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

 
Old February 23rd, 2005, 07:31 PM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

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

dartcoach
 
Old February 23rd, 2005, 07:40 PM
Authorized User
 
Join Date: Feb 2005
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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!!!!

 
Old February 23rd, 2005, 07:45 PM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

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









Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.