You are viewing an obsolete version of the DU website which is no longer supported by the Administrators. Visit The New DU.
Democratic Underground Latest Greatest Lobby Journals Search Options Help Login
Google

Reply #8: I know nothing of MS Access [View All]

Printer-friendly format Printer-friendly format
Printer-friendly format Email this thread to a friend
Printer-friendly format Bookmark this thread
This topic is archived.
Home » Discuss » The DU Lounge Donate to DU
billyskank Donating Member (1000+ posts) Send PM | Profile | Ignore Tue May-10-05 01:20 PM
Response to Reply #4
8. I know nothing of MS Access
although I do know about SQL, being an Oracle developer. In Oracle, your WHERE clause "((tbEnrollments.NumericGrade) = MIN("grade"))" would not be allowed, unless MIN(grade) happened to be one of the columns in the select list.

What you would need to do is use a subquery:

AND tbEnrollments.NumericGrade = (
SELECT MIN(grade)
FROM whatever
WHERE wherever
)

Dunno if that will help you...
Printer Friendly | Permalink |  | Top
 
  -I am very very needy for DBMS qry help! :) miss_kitty  May-10-05 12:31 PM   #0 
  - hmm:  unblock   May-10-05 12:44 PM   #1 
  - I'll Try that. I was messing around with 6 right now  miss_kitty   May-10-05 12:49 PM   #2 
  - ok when I stick Min grade into criteria I get this:  miss_kitty   May-10-05 12:59 PM   #4 
     - I know nothing of MS Access  billyskank   May-10-05 01:20 PM   #8 
     - It might.!:)  miss_kitty   May-10-05 01:28 PM   #9 
        - min () should be fine in the select statement  unblock   May-10-05 01:37 PM   #12 
        - min () should be fine in the select statement  unblock   May-10-05 01:37 PM   #13 
     - the first response seems to solve the problem  welshTerrier2   May-10-05 01:41 PM   #17 
        - I don't know HOW to place it in the SELECT list  miss_kitty   May-10-05 01:50 PM   #21 
           - Well, if Access' implementation of SQL is anything like normal  billyskank   May-10-05 01:53 PM   #22 
           - Ok. I don't know what foo and baz means, but you are right  miss_kitty   May-10-05 01:56 PM   #24 
           - try this ...  welshTerrier2   May-10-05 02:05 PM   #26 
  - All I can offer you is candy.  JimmyJazz   May-10-05 12:50 PM   #3 
  - Thankyou  miss_kitty   May-10-05 01:01 PM   #5 
     - Sure. sure, but you'll accept Swedish Fish from skinner!  JimmyJazz   May-10-05 01:03 PM   #6 
        - I have never run across a nut in a Swedish Fish  miss_kitty   May-10-05 01:11 PM   #7 
  - Trick Question. Access isn't a DBMS, it's Excel+  DS1   May-10-05 01:30 PM   #10 
  - i would say it's excel--  unblock   May-10-05 01:35 PM   #11 
  - Or Word++  miss_kitty   May-10-05 01:39 PM   #14 
     - Paint+++  DS1   May-10-05 01:43 PM   #18 
        - Calculator ++++?  miss_kitty   May-10-05 01:45 PM   #20 
           - cmd5  DS1   May-10-05 02:04 PM   #25 
  - is this in English?  northzax   May-10-05 01:41 PM   #15 
  - Actually it's SQL  miss_kitty   May-10-05 01:44 PM   #19 
  - OK thank you I am a total dumbass and must go to The Computer Lab  miss_kitty   May-10-05 01:41 PM   #16 
  - Self Delete  Yavin4   May-10-05 01:54 PM   #23 
  - OK! I GOT THE ANSWERS. And I KNOW you all were telling me  miss_kitty   May-10-05 06:12 PM   #27 
 

Home » Discuss » The DU Lounge Donate to DU

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators


Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.

Home  |  Discussion Forums  |  Journals |  Store  |  Donate

About DU  |  Contact Us  |  Privacy Policy

Got a message for Democratic Underground? Click here to send us a message.

© 2001 - 2011 Democratic Underground, LLC