Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    9

    Unanswered: i need just a simple help..

    Hi!

    here's my problem...

    select query - criteria

    Criteria that i tried..

    1.) Not Like "*Plan Max*"
    2.) Not Like '*Plan Max*'
    3.)<> "*Plan Max*"

    whats wrong with this.. i need to select all records from a table (Plan Details) that does not contain a "Plan Max".. Records in the table (Plan Details) are strings.. heres's a sample of a record in the Plan Detail table

    1.)DBWMM - Monthly Recurring, DWLI1 - Plan Max SPAN Internet Access
    2.)DBWD4 - 499 Star One Month Deposit, DBWMM - Monthly Recurring Fee
    3.)DBWD6 - 699 Star One Month Deposit, DMWLL - Monthly Recurring Fee

    i need to select all record that does not contain Plan Max, in above example i need to select the records 2 and 3.

    Help...

    Thanks..

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    What's the SQL look like?
    Me.Geek = True

  3. #3
    Join Date
    Jul 2009
    Posts
    9
    sir what do you mean about sql? i dont use any sql.. its just pure access..

  4. #4
    Join Date
    May 2005
    Posts
    1,191
    SQL is the language that queries are made on, it's ubiquitous to all major database programs. I take it that you're using Access' query wizard to build this query, and thus you are unfamiliar with the language itself. The wizard is just a pretty tool to build the SQL string for you, you're writing SQL without knowing it

    To view the SQL that the wizard is making for you, go to the top-left view pull down, and choose SQL view. It'll show you a bunch of text, copy and paste it into a post and we'll see if we can help you a little more.
    Me.Geek = True

  5. #5
    Join Date
    Jul 2009
    Posts
    9
    thanks for the advise..

    ive already solve my problem..

    thanks..

Posting Permissions

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