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