Comparison Operators for Access 2007

By Laurie Ulrich Fuller, Ken Cook, John Kaufeld

Part of Access 2007 For Dummies Cheat Sheet

The databases you build with Access 2007 are meant to be searchable — or what’s the point? In order to search through an Access database, you need to use comparison operators that will pull up the information you’re looking for. The following table shows the symbols to use to bring up the data you want: