View Single Post
  #9 (permalink)  
Old January 12th, 2005, 01:54 PM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Quote:
quote:Originally posted by sprionActually though, I'm hoping to see some SQL statements instead
If you open the query in design view, you can click on VIEW and choose SQL. That will show you the SQL language for it.

Quote:
quote:Also, I think I need a random NOK of Jack's to be used, rather than the TOTAL NOKs he has.
If you show the relationship rather than the count if it, you'll end up getting three Jacks again. That may be desirable in a game of Poker, but not here!


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote