• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

SQL Search

Finding information within your database can be a simple or a complex process. Depending on the search criteria, you can give your users the capability to narrow down their searches as fine as a specific date range. Suppose you wanted to find all customers within your database that had a last name of Smith; you could create a simple query within Access that selected all the records within the customers table whose last name was equivalent to the name Smith. Your SQL statement could look similar to

SELECT LastName FROM Customers WHERE LastName = 'Smith' 


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint