Solved

Filtering from Microsoft Acccess

Posted on 2009-07-16
6
176 Views
Last Modified: 2013-11-28
I am filtering out using <> "MISCELLANOUS"    in the criteria field I need to add more How do I do this in access?
1. <>"MISCELLANOUS" And "Jill Boski"
2. <>"MISCELLANOUS" And <>"Jill Boski"
3. <>"MISCELLANOUS" <>"Jill Boski"

or do I use the or column
0
Comment
Question by:gotti777
  • 3
  • 3
6 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
Comment Utility
Hi gotti777,

As in #2
<>"MISCELLANOUS" And <>"Jill Boski"

Good Luck!

Gary
0
 

Author Comment

by:gotti777
Comment Utility
Hmmm I try that and Misc seem to fall out but i still get Jill's
SELECT Invoice.WrittenBy AS [INS Rep], [Invoice Line Detail-View].CustomerName AS Customer, Invoice.SONumber AS [Order], [Invoice Line Detail-View].Item, [Invoice Line].DateRequired AS [Required Date], [Invoice Line].DatePromised, Invoice.DateShipped, [DatePromised]-[DateShipped] AS Expr1

FROM ([Invoice Line Detail-View] LEFT JOIN [Invoice Line] ON ([Invoice Line Detail-View].InvoiceNumber = [Invoice Line].InvoiceNumber) AND ([Invoice Line Detail-View].InvoiceLineNumber = [Invoice Line].InvoiceLineNumber)) LEFT JOIN Invoice ON [Invoice Line Detail-View].InvoiceNumber = Invoice.InvoiceNumber

WHERE (((Invoice.WrittenBy)="RIC WETHERBEE") AND (([Invoice Line Detail-View].CustomerName)<>"Dwight Long") AND (([Invoice Line Detail-View].Item)<>"MISCELLANOUS" And ([Invoice Line Detail-View].Item)<>"Jill Boski") AND ((Invoice.DateShipped)>=#1/1/2009# And (Invoice.DateShipped)<=#3/31/2009#) AND ((Invoice.InvoiceType)="SHIP"));

Open in new window

0
 

Author Comment

by:gotti777
Comment Utility
Never Mind .. I was filitering wrong spot ... stupid me thanks..
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Closing Comment

by:gotti777
Comment Utility
thanks
0
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
Might be to do with your joins
0
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
Glad to help!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Spell checking an unbound form in MS Access 2013 9 34
Access 2010 3 15
putting an icon in a form 13 18
sql calculate averages 18 17
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now