Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

LIKE Operator in MS Access 97

urbanurban Member Posts: 11
To use a LIKE operator in a Filter statement in Access?

For example in the OpenForm command, the Filter is: [Registration]=[Forms]![SearchbyReg]![txtReg]

How would i make it a LIKE operator? Or can i use a normal SQL statement, and how would i open the form using that?

Thanks! :)

Comments

  • nwdurcholznwdurcholz Member Posts: 3
    You use it exactly as you would in a query: [Registration] Like [Forms]![SearchbyReg]![txtReg]. Filters are constructed the same and behave the same as SQL WHERE clauses. The only difference between them is that in a filter, you don't need the word "WHERE".


    thanks,
    Nick

  • Chris BrownChris Brown USAMember Posts: 4,496 ✭✭

    _____ < http://forcoder.org /> free video tutorials and ebooks about ( MATLAB Perl C++ Assembly JavaScript Java Swift PL/SQL Ruby Visual Basic Objective-C Visual Basic .NET PHP C# C R Scratch Delphi Python Go Crystal Dart ML FoxPro Julia Rust Alice Lua Bash Prolog Lisp Transact-SQL Scala LabVIEW Ada Kotlin D Fortran F# Hack ABAP Scheme SAS Clojure COBOL Awk Logo Erlang Apex VBScript ) ______

Sign In or Register to comment.