Results 1 to 14 of 14

Thread: [RESOLVED] - why i got an error here in my query?

Threaded View

  1. Mar 30th, 2006, 03:20 AM #1
    noielen
    noielen is offline

    Thread Starter
    Fanatic Member noielen's Avatar
    Join Date
    Nov 2005
    Location
    Cebu, Phil.
    Posts
    680

    Resolved [RESOLVED] - why i got an error here in my query?

    Pls. do comments here in my query
    VB Code:
    1. rsbrand.Open "SELECT MARGIN, BRAND, SUM(ADAMOUNT) as adamount1 FROM INITIAL_QUOTE_DETAIL GROUP BY BRAND ORDER BY BRAND", conn, adOpenDynamic, adLockOptimistic
    why i got an error?
    Error occured: "You tried to execute a query that does not include the specified expression MARGIN as part of an aggregate function"

    Any help really appreciated... Thanks in advance
    Last edited by noielen; Mar 30th, 2006 at 04:39 AM.
    noister
    <advertising link removed by moderator>
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width