[AccessD] DatePart Question

Hi Gina

> ..  I have a table full of data that I need to query, and what I
> need returned is the data from last month. 

Why not use DateDiff():

<SQL>

  SELECT
    *
  FROM
    tblYourTable
  WHERE
    DateDiff("m",[PeriodEnd],Date())=1;

</SQL>

/gustav