microsoft ultimate steal
http://www.microsoftstore.com/store/msstore/cat/categoryID.37826100

* import from Excel into Access
my advice: make sure that data type of foreign keys
and primary keys are set to what you want on import.
otherwise, you will problems in establishing relationships
in the relationship window.
set the primary key on Import

* In queries, here are the wildcards:
* means match anything, including nothing
j*sh
will match:
jsh
josh
jithsh
? means matching exactly one characted
j?sh
will match
josh
jish
NOT match jsh
NOT match jiiiish
contains Excel
*Excel*
Learning Excel Formulas
Excel Formulas 2010
Learning Excel
begins with
G*
Grauer
ends with
*ing
Starling

Like "*Excel*"


Today's date: Dec 16
Publish Date: Dec 1
Today's Date MINUS Publish Date <= 60
DATE() - PublDate <= 60


SELECT Book.Title, Book.Price, Book.PublDate
FROM Book
WHERE Book.PublDate > Date()-60;

joshwaxman@gmail.com